Multiple Reports

[DS]

Hi Folks,

I've got an a application that prints a number of reports. The contents of the reports are based on a the user selecting a set of criteria to base the data extract on and the type of report to generate - a list, a pie chart or a bar graph. Each one of these types of reports has its own report template so in all there are three reports and the application simply sets the recordsource property of the required report before the openreport command is issued.

The problem I have is that the user can batch any number of these reports, and then simply rerun the batch whenever the complete set is required. However, the way this is done is to open each report in the batch one at a time, preview it, then close it and open the next report. What I want to do is to be able to produce all the reports(invariably it is one page per report) as multiple pages of a single report.

Any thoughts/ideas??

Thanks
DS

 

[Fornatian]

I had a similar problem.

What I did was build one report with multiple sub-reports and multiple page breaks.

I then had a no of check boxes where users could select which parts they wish to view and conditionally the visible property of both the page breaks and reports would be set to TRUE. To the user it looks like one report.

Good luck.

if I recall do a help search on conditional page breaks, should be a good place to start.

Ian

 

[DS]

Thanks.

I was thinking of the same, but if my memory serves me right, sub-reports do not replicate ALL the controls of the underlying 'sub-report'. My reports already have a couple of sub-reports (Heading and the Data). Anyway, I'll give it a go (also I do not know in advance how many reports will be batched, so do I just set up a number and 'swith off' the ones i'm not using?)

Thanks
DS

 

[Fornatian]

The problems I encountered were that you can only 'stack' three subreports inside each other

The way I got round it was to build a query for a couple of the tables I had included and then built a report that grouped the info by the superior table in the query(thereby reducing the no of subreports by 1).

In answer to your question what I did was build an unbound criteria form(assume Name: frmCrit)with a check box(assume Name: cbxAny) for each subreport I want to include in the report as an option, a subreport(assume Name:subrptAny) and a corresponding page break(assume NamegbAny). Both of these objects visible properties were set to false in report design view.

If Forms(frmCrit).cbxAny = True Then
Me![subrptAny].Visible = True
End If

I included one of these if statement for each report that might be included.

There is a little more work to do regarding the pagebreaks but you can read about that in the 'page break' help - basically you need to do a similar hide/unhide action dependent on the value in cbxAny.

Note: You can't close the unbound criteria form while the report is opening or formatting because it refers to the control values constantly - I got round it by having a non-modal form(alternatively you could just set the forms visible property to false when the form is open and to true when closed)

Hope this is a little extra help

Ian


Ian