Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to show first record on each page? 1

Status
Not open for further replies.

manishw

Programmer
Jun 15, 2005
16
US
Hello,
I have a few fields which I display on the Crystal report.
I am suppressing some of those fields conditionally using the formula

Not OnFirstRecord
And
{fieldName} = Previous (fieldName)

However, I also want to display those fields for first record on each page.

How can I go about doing that?

Thanks,
Manish
 
Create two formulas:

//{@reset} to be placed in the page header:
whileprintingrecords;
numbervar cnt := 0;

//{@cnt} to be placed in the detail section:
whileprintingrecords;
numbervar cnt := cnt + 1;

Then change your suppression formula to:

whileprintingrecords;
numbervar cnt;
Not OnFirstRecord And
{fieldName} = Previous (fieldName) and
cnt <> 1

-LB
 
That was excellent LB :) It was simple and brilliant.

Thanks a ton.
Manish
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top