Crystal Reports Suppress Field Formula but not on top of new page

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Suppress Field Formula but not on top of new page

Author	Message
Masinya Newbie Joined: 20 Jun 2014 Location: Canada Online Status: Offline Posts: 1	Topic: Suppress Field Formula but not on top of new page Posted: 20 Jun 2014 at 7:29am
	I have a report that I use the suppress formula: if previous(field) = field. It works great, however I want the field to display on the top of a new page. What is the best way to do this? Thanks. Edited by Masinya - 20 Jun 2014 at 11:24am
	IP Logged


hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 24 Jun 2014 at 9:32am
	Assuming that the field is in the details, I would do the following: 1. Create a group header section just above the details section. 2. Set the group to "Repeat Group Header on Every Page". 3. Put the field in the header section 4. In the Section Expert, turn on "Underlay Following" for the section. 5. Add the following to the suppression formula for the section: not InRepeatedGroupHeader This will configure the section to appear only when the group header is being repeated because the data spans multiple pages. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 25 Jun 2014 at 7:59am
	Also if you are only suppressing the field, not the entire row based on the condition of the field itself being duplicated then you can use the 'suppress if duplicated' check box in the Format Field Common tab. It will display the field on the first row and on the first row of a subsequent page. If you are suppressing a field based on the duplication of another field you can use that as the condition in the 'suppress if duplicated' option.
	IP Logged

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum