Print Page | Close Window

Suppress All But the First/Last Result Line

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18345
Printed Date: 17 May 2024 at 8:42pm


Topic: Suppress All But the First/Last Result Line
Posted By: MrSamNC
Subject: Suppress All But the First/Last Result Line
Date 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


Replies:
Posted By: DBlank
Date 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

Posted By: guptaa
Date 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.



-------------
Aradhana

Posted By: DBlank
Date 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])

Posted By: guptaa
Date 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

Posted By: DBlank
Date 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])
 

Posted By: guptaa
Date Posted: 25 Feb 2013 at 1:48pm
thanks very much. It works.

-------------
Aradhana


Print Page | Close Window