Keeping last record with Grouping

Posted by yeahumok on Stack Overflow See other posts from Stack Overflow or by yeahumok
Published on 2010-04-01T15:40:33Z Indexed on 2010/04/01 15:43 UTC
Read the original article Hit count: 275

Filed under:

crystal-reports

|

grouping

Hi All

I have a report that groups by Company names. I have 2 formula fields (for two of the columns) that pulls the last record from a field. However, i noticed that when i run my reports, it does not show the last record for every group (even though this total line is in the Group Footer).

Is there anyway in the formula field, i can specify that the last record must show for every group in my report?

© Stack Overflow or respective owner

Related posts about crystal-reports

Crystal Reports: Save Time with Formula Sharing

as seen on ASP alliance - Search for 'ASP alliance'
Once a report library grows to a certain size there are always going to be common formulas which are needed repeatedly. Having easier access to them can save a lot of development time. >>> More
Automate delivery of Crystal Reports With a Windows Service

as seen on ASP alliance - Search for 'ASP alliance'
In this article, Vince demonstrates the creation of a Windows Service to automatically run and send a Crystal Report as an email attachment. After a basic introduction, he examines the creation of the database and windows service with the help of relevant source code and explanations. Towards the… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More
Crystal Reports: 5 Tests for Top Performance

as seen on ASP alliance - Search for 'ASP alliance'
Your masterpiece report is now complete. It doesn't just meet your customer’s expectations, it blows them out of the water. All they want is a beautifully-summarized report that can be displayed in a myriad of ways. Then disaster strikes! You try to run the report for a month against the live database… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More

Related posts about grouping

Grouping every 3 items in xslt 1.0

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having troubles to figure out a way to group items xslt 1.0. I have a source xml similar to the one below: <client name="client A"> <project name = "project A1"/> <project name = "project A2"/> <project name = "project A3"/> <project name = "project… >>> More
Introducing the Tablix Data Region: Basic Grouping Concepts

as seen on Internet.com - Search for 'Internet.com'
BI Architect Bill Pearson continues his examination of the general characteristics and properties of the Tablix data region, which debuts in Reporting Services 2008. Here, we discuss further concepts, and begin our hands-on examination of a Tablix data region in a working sample report. >>> More
Dynamic Grouping and Columns

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Some good collaboration between myself and Kan Nishida (Oracle BIP Consulting) over at bipconsulting on a question that came in yesterday to an internal mailing list. Is there a way to allow columns to be place into a template dynamically? This would be similar to the Answers Column selector. A customer… >>> More
Fastest way to group units that can see each other?

as seen on Game Development - Search for 'Game Development'
In the 2D game I'm working with, the game engine is able to give me, for each unit, the list of other units that are in its view range. I would like to know if there is an established algorithm to sort the units in groups, where each group would be defined by all those units which are "connected"… >>> More
Python: Improving long cumulative sum

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a program that operates on a large set of experimental data. The data is stored as a list of objects that are instances of a class with the following attributes: time_point - the time of the sample cluster - the name of the cluster of nodes from which the sample was taken code - the name… >>> More