| Author |
Message |
bshort1023
Newbie
Joined: 18 Jan 2012
Location: United States
Online Status: Offline
Posts: 18
|
   Topic: Print Top 10 Detail Records per Group
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
|
 IP Logged |
|
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
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
|
|
IP Logged |
|
bshort1023
Newbie
Joined: 18 Jan 2012
Location: United States
Online Status: Offline
Posts: 18
|
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
|
|
IP Logged |
|
Sastry
Moderator
Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
|
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
|
|
IP Logged |
|
CamiloRobles
Newbie
Joined: 17 Aug 2017
Location: Mexico
Online Status: Offline
Posts: 3
|
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
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 21 Aug 2017 at 9:37am |
|
are you resetting the page number after the group footer?
|
|
IP Logged |
|
CamiloRobles
Newbie
Joined: 17 Aug 2017
Location: Mexico
Online Status: Offline
Posts: 3
|
Posted: 21 Aug 2017 at 3:12pm |
Yes,
Edited by CamiloRobles - 21 Aug 2017 at 3:14pm
|
|
Saludos!
Camilo
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
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.
|
|
IP Logged |
|
CamiloRobles
Newbie
Joined: 17 Aug 2017
Location: Mexico
Online Status: Offline
Posts: 3
|
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
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
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?
|
|
IP Logged |
|
|
|
