Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
As we let our own light shine, we unconsciously give other people permission to do the same
 
Marianne Williamson
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

24
October

How Do I Highlight the First x No of Rows in a Grouped Report in Crystal Reports 2008?

Over the last couple of weeks I have been asked a number of times by clients "How Do I Highlight the First x Number of Records in a Group Report in Crystal Reports 2008?"



Solution:

There are a number of methods of doing this, but the key thing is to get the record number to reset to 0 at the begining of each group.

To highlight the First x Number of records per group:

  1. Create a Parameter Field, that asks the user the number of records to be highlighted

  2. Create a Running Total Feld that counts the number of records per group and resets the count to zero when a new group starts.

  3. From the Report menu select the Section Expert menu option

  4. In the Section Expert dialog box, select the Details section

  5. Click on the Color Tab

  6. Press the Conditional format button(X + 2)

  7. In the Formula Workshop enter the following formula:

    IF {#Running Total Field} <= {?Parameter Field} THEN Color (192,254 ,37 ) ELSE crNoColor

  8. Press the Save & Close Button

  9. Press the OK button



If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

15 + 61 =