Running multiple reports from Report Explorer with single autosearch popup

rbuser

Hi,

Does anyone know of a way of being able to run multiple reports that have
autosearch filters from the report explorer but only ever having the
auto-search dialog popup once with all the filters (no duplicates) show for
all the reports selected.

I saw a post last year (which I can not find) which I think suggested
loading each report and creating a list of the autosearch critieria fields
and then building a report with each of the selected reports as sub reports
(or something to that effect ???) and the distinct list of filtering
criteria.

Some sample code would be ideal, but even a response from someone that has
successfully done this before would be appreciated.

Thanks in advance,

Jarrod

rbuser

Further to this I would like to give the end user the ability to show all
the reports in a preview screen before the user prints them as well. N.B:
There may be different criteria in each report

nardmoseley

If you want to previewnd print the selected reports as a single report then
you need to dynamically build a new 'main' report that contains each of the
selected reports as a subreport section.

A first incremental step would be to use the ReportDesigner to create a
sample. Then work on the dynamic generation as a second step.

1. Create a new report and remove the header and footer so that there is
only a single band - the detail band. Do not connect the report to any
datapipline.

2. Add a subreport and set PrintBehavior to pbSection.

3. Access the workspace for the subreport and select File | Load
Subreport.... and choose a report to load.

4. Repeate steps 2 and 3 to add additional sections to the main report.

5. You should now be able to preview and print.

Dynamic generation:

See the Codebased thread of the Tech Tips newsgroups.





--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com