Print Page | Close Window

Database field repeating

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15352
Printed Date: 02 May 2024 at 6:14pm


Topic: Database field repeating
Posted By: ghusong
Subject: Database field repeating
Date Posted: 12 Jan 2012 at 4:42am
I have set up a simple report to list the unconfirmed pick tickets as a checklist for the warehouse.The database field is pick_ticket_no. I just want to see this number one time. It is repeating this number for each item_id listed on the open pick ticket.
We don't need to see the items.
This is taking up a huge amount of space on the report. All of the other fields are repeating also for each theoretical item Id.
How can I suppress all of the unneeded extra data...


Replies:
Posted By: DBlank
Date Posted: 12 Jan 2012 at 4:53am
2 possible solutions:
you can conditionally suppress the detail section using
Next(table.pick_ticket_no)=table.pick_ticket_no
 
Or you can group on the ticketno field and place your disply needs ont he group header and suppress all detail rows (and GF1).
whatever fields you place on the GH will show you the value fm your data set that is the first row of data for that group.


Print Page | Close Window