CR8.5 Advanced Groups 2

[firstNbank]

Yes, I have tryed to use the footer to start a new page, but I don't think it will work in this case. Please see below.

summary and details.


(For eg., If I have variable account numbers, I will group by account number, each number has transaction fields and address fields that make up about 6 lines of text. sometimes there could be up to 3 accounts per page. How would I group these on the same page?>

I Also need to reset the page numbering after each group. This means each
group should have its own page numebring starting from 1. I need to
display 3 fields on the main report:
one which displays how many total pages were created for all the groups,
second which displays the total number of pages created for that group
and third which displays the current page number for that group.

And also I have to create a summary page at the beginning of the report
which displays each group and the total number of pages created for that
group something like:

Customer1 3 pages created
Customer2 5 pages created
Customer3 8 pages created
...............

I'm generating the summary by way of a subreport by calling from the
main report.

Can anyone tell me how I can set these dynamically. Is there any option in Crystal report which helps me to do this? Your help is highly appreciated

 

[paulmarr]

firstNbank,

To be truthful you are asking to accomplish several different report design concepts which are not basic in nature - so as an instructor I would suggest you need some Crystal training!

The reset page number is an easy one - in the Section Expert - which can be located on the toolbar as a button or from the Report Menu - highlight the Group Footer section of the Customer grouping in the left window, and find and tick Reset Page Number After.

Total Pages for all groups - formula using "TotalPageCount" function in the Print State folder in the Functions window of the Formula Editor.

Current Page Number - is the special field "PageNumber"
Total Number of pages for group - formula that counts the pages and resets for each group.

I wouldn't think you would need a subreport - but store these values in a variable or variable array and then recall them to display. ( in formulas of course)

Hope this points you in the right direction. (training!)

Cheers,

paulmarr