Multiple reports, continuing page number 
Author Message
 Multiple reports, continuing page number

Hi!

        I understand that Crystal Report can't use sub-reports... A very nice
feature that I've learned to like very much in Access.

        I need to print several pages of data, which are independant of each
other. The only way I found was to print each page as an independant
report.

        My problem is that I want to have a page number on the bottom of the
reports, which would make the reports appears as one big report. Is there a
way to know the number of pages needed to print a report, and then to pass
this information to another report?

        I use VB4-16 and a access database, running on Win 3.1 (there is NO way I
can use Access)

        Thanks for your help, please reply directly to me at



Tue, 25 Apr 2000 03:00:00 GMT  
 Multiple reports, continuing page number

Hi Banque,
You should use Crystal Reports 4.6 or higher. Now to your problem. If
your subreports are totally independent, you will create an empty dummy
report. If you place the page number into the page footer and insert two
simple subreports into the detail section of your report you'll get the
result you want. I've tried it a minute ago, it worked.

Ther may be problems to parameterize the subreports. This is possible
thru formula fields. You can link the outer formula fields to inner
subreport formulas or you can change the SQL-Statements of each
Subreport independently by using the API. See the help file.

Hope it'll help

Quote:

> Hi!

>         I understand that Crystal Report can't use sub-reports... A very nice
> feature that I've learned to like very much in Access.

>         I need to print several pages of data, which are independant of each
> other. The only way I found was to print each page as an independant
> report.

>         My problem is that I want to have a page number on the bottom of the
> reports, which would make the reports appears as one big report. Is there a
> way to know the number of pages needed to print a report, and then to pass
> this information to another report?

>         I use VB4-16 and a access database, running on Win 3.1 (there is NO way I
> can use Access)

>         Thanks for your help, please reply directly to me at




Tue, 25 Apr 2000 03:00:00 GMT  
 Multiple reports, continuing page number

Crystal 5.0 and possibly even 4.5 does do subreports.  On the Insert menu
pick subreport and draw it in  It can be anywhere. From your description it
looks like you would run the first report and then in the footer run the
sub report that would be the second report. I usually have each subreport
in its own section so if I had two subreports I would have two report
footer sections.



Sat, 29 Apr 2000 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Multiple reports, continuing page header ??

2. Consecutive page numbers on multiple reports

3. Printing multiple page report to multiple bins for collating vb4.0 Crystal 5

4. Help Multiple page Report with Crystal Report

5. How to Reset the Pages Number on Group Level in a Report

6. Page Numbering for grouped reports

7. Continuous pages for multiple reports

8. Code to place page number text on report

9. Page number problem in Access 2 reports!

10. Printing multiple pages of a report

11. return the page number from a report

12. Pausing Access Reports based on page numbers

 

 
Powered by phpBB® Forum Software