Weird Problem

[harding1031]

CR v 9.0
I have a grouped report that have multiple pages per group. I only want to print the first page of each group.
I used "pagenumber<>1" to suppress all subsequent pages, almost works fine. The problem is when I put this formula for suppression of GF1, only the first group prints, when I remove the formula, a blank page with only the GF1 prints after each 1st page of the group. I also set the "newpage after" in the GF1 section to reset page number after each complete group.

I want my output to look like below for each group.
GH1
GH2
detail(one page)
GF2
GF1

 

[dgillz]

When you say "I only want to print the 1st page of each group", can explain this? Most likely this can be done in another way.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[lbass]

I remember your earlier post where you said there were hundreds of pages per group, but you only wanted to show the first page. The pagenumber <> 1 solution (mine) doesn't work, when I test it, but I see now that you want to show the group footer--which wouldn't appear unless you were only suppressing detail records.

Also I'm not sure whether you want to show one page per group#1/group#2 combination either, but I think you should try the following: Create a running total {#cntwingrp} using the running total expert where you choose a recurring field, count, evaluate for each record, reset on change of group (#1 or #2, depending upon whether you want one page for each Group #1 or Group #2). Then go to the section expert->details->suppress->x+2 and enter:

{#cntwingrp} > 40 //pick the number that will result in only one page of details with group footer and header sections.

-LB

 

[synapsevampire]

Makes sense.

Try using a different method:

Group header formula:
whileprintingrecords;
numbervar CurrPage := pagenumber;

Now in all subsequent sections that you wish to suppress use the following formula:

whileprintingrecords;
numbervar CurrPage;
Currpage<>pagenumber

It should now suppress if the page number isn't the same as the page number for the group header.

-k

 

[harding1031]

OK, for each group printed there will be about of 100 pages per group. I have about 3 groups-about 300 pages. I want to print only the first page of each group - 3 pages total printed. For example
grp header 1
page1(print)
page2(suppress)
...suppress rest of pages
grp footer 1
grp header 2
page1(print)
page2(suppress)
...suppress rest of pages
grp footer 2

 

[dgillz]

The key question is why are you getting 300 pages in the first place? Please post example data, table relationships and expected output.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[harding1031]

Thanks guys, you all are great!!! I am going to try this.