Print Top 10 Detail Records per Group
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=20580
Printed Date: 05 May 2024 at 5:48am
Topic: Print Top 10 Detail Records per Group
Posted By: bshort1023
Subject: Print Top 10 Detail Records per Group
Date Posted: 26 Mar 2014 at 8:59am
|
I have a Crystal 2008 report that will have one group (part number). I would like to print on the first 10 detail records associated with the part per group (so I would have one page per group). So if I run the report for 8 parts I would have 8 pages with up to 10 detail records on each page. This sounded easy enough but I can't figure out how to do it. Thanks, Bill |
Replies:
Posted By: DBlank
Date Posted: 26 Mar 2014 at 9:34am
|
so if you have 11 details the 11th does not show at all, correct?
in the section expert set the gf to new page after formula as
not onlastrecord
create a Running total
name = suppressCount
field to summarize = anything
type = count
reset = on group change
in the detail section use the suppression fomrual of
#suppressCount>10
|
Posted By: bshort1023
Date Posted: 24 Apr 2014 at 5:11am
|
Ok my parameters have changed. It seems that 10 records are not enough in some cases. What I would like to do is print only the first page in each group. I tried Suppress if "PageNumber <> 1" in the details section. I then set the Group Footer, Report Footer and Page Footer to Suppress. Now I get the first page correct but a blank 2nd page. TIA. Bill |
Posted By: Sastry
Date Posted: 27 Apr 2014 at 3:05am
|
Hi You need to apply the same condition for rest of the sections also.. like page header / report header / group header / group footer.. PageNumber <> 1 and go in section expert and check, suppress blank sections check box for all sections. Also check New page Before or After selection for any sections. If so, uncheck that option. -Sastry ------------- Thanks, Sastry |
Posted By: CamiloRobles
Date Posted: 21 Aug 2017 at 7:35am
|
Hi, I have the same problem; when I do what Sastry says, I have the first page and a blank page ¿what can I do? ------------- Saludos! Camilo |
Posted By: DBlank
Date Posted: 21 Aug 2017 at 9:37am
| are you resetting the page number after the group footer? |
Posted By: CamiloRobles
Date Posted: 21 Aug 2017 at 3:12pm
Yes,
 ------------- Saludos! Camilo |
Posted By: DBlank
Date Posted: 22 Aug 2017 at 2:48am
|
what is your suppression formula?
Remove your suppression formula and place the page number on in the page footer and verify that the report is doing the numbering (and group printing) as you would need it to match your suppression criteria. |
Posted By: CamiloRobles
Date Posted: 22 Aug 2017 at 8:01am
|
My suppression formula is"PageNumber <> 1"
If I remove the suppression formula all pages are printed and page number in the footer shows what I expect. e.g. First group needs 3 pages, so pages are numbered from 1 to 3. Second group needs 2 pages, page number is 1 and 2, an so on. ------------- Saludos! Camilo |
Posted By: DBlank
Date Posted: 22 Aug 2017 at 8:56am
|
From my testing, the page number does not seem to be resetting when the GF is suppressed.
If you remove the suppression formula from the GF It seems to 'work' except it still prints a 'blank' page after any group that is larger than 1 page. I am not having much luck on a combo that resolves that issue. Anyone have thoughts on this? |