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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppressing Details section

Status
Not open for further replies.

keeno

MIS
Feb 24, 2006
33
GB
Hello

I have a report which returns a number of 'Updates' in the details section of the report. I would like to restrict the number of details that is displayed so only the latest 'UPDATE' is displayed.

Any help you can give would be greatly appreciated

Thanks

David
 
Sort your report so that the latest update is at the bottom. Then place the fields you want to see in the report or group footer (if your report is grouped), and hid the details section.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
 
Or you could go to report->selection formula->GROUP and enter:

{table.update} = maximum({table.update},{table.groupfield})

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top