Crystal Reports Suppress All But the First/Last Result Line

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

Topic: Suppress All But the First/Last Result Line

Author	Message
MrSamNC Newbie Joined: 02 Jan 2013 Location: United States Online Status: Offline Posts: 1	Topic: Suppress All But the First/Last Result Line Posted: 02 Jan 2013 at 1:50am
	I used to have this somewhere, but it's lost now. I need to suppress all but the first (or last, depending on Sort) line of results in the details section. For example: -ORIGINAL- Pt 1 Lab Value 10/2012 - 10.0 11/2012 - 11.5 12/2012 - 9.7 -DESIRED FORMAT- Pt 1 Lab Value 12/2012 - 9.7 Thanks, Sam
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 02 Jan 2013 at 3:31am
	move teh values to a header or a footer and suppress all of the detail sections or you can use a supress formula of either not onfirstrecord not onlastrecord
	IP Logged

guptaa Newbie Joined: 21 Feb 2013 Location: United States Online Status: Offline Posts: 14	Posted: 21 Feb 2013 at 9:56am
	This is my first time on this forum and this is the closest topic I found with the help I was looking for: I need to suppress printing of footer text on every page except 1 & 3 page for every child_id. Report is grouped on Child_id and there can be many of them. There are 3 pages total / child_id. Any advise would be appreciated. Thanks. Edited by guptaa - 21 Feb 2013 at 12:03pm
	Aradhana
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 21 Feb 2013 at 10:23am
	in teh section expert reset the page number after the group footer conditionally supress the section or the text object using not(pagenumber in [1,3])
	IP Logged

guptaa Newbie Joined: 21 Feb 2013 Location: United States Online Status: Offline Posts: 14	Posted: 21 Feb 2013 at 12:34pm
	I am not able to write the suppress condition for: "after the group footer". I am not sure how to write this. Thanks for helping me out.
	Aradhana
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 22 Feb 2013 at 6:38am
	in the section expert select the group footer section click on the formula box (x-2) nect to the supress option and add your condition in thsi formula editor. True means supress, false means show so you can use *not(pagenumber in [1,3])*
	IP Logged

guptaa Newbie Joined: 21 Feb 2013 Location: United States Online Status: Offline Posts: 14	Posted: 25 Feb 2013 at 1:48pm
	thanks very much. It works.
	Aradhana
	IP Logged

Post Reply

Post New Topic

Printable version

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

This page was generated in 0.031 seconds.