Hi Cognoise friends,
I have 18 reports with complex logics but has the same prompt page (date range, location and product type).
I need to build a master report which would prompt for filters (date range, location and product type) then run all those 18 reports and display the report output (1 to 18 sequentially) in a single PDF file.
How can I achieve this using Cognos 10 report studio ?
Thanks in advance,
Slim.
I don't believe its possible. You can copy all of the queries and report pages into a single report, then run it and generate a single PDF.
18 reports with complex logic would be a little too much to copy paste into one report. Why not go for a drill through option?
Because if he needs it in one pdf file, without merging the single pdfs afterwards cognos has no possibiliy to connect the report outputs of reports after execution.
Therefore i agree with tjohnson, i think the best way is to create a new report, lets call it a "report map" with the one prompt page.
The drill solution might work, if u create a drill to all 18 reports and after the pdf files got saved, have a batch or job which collect them and merge them with a third party pdf tool.
I prefer the first solution though ;)
regards
Combining the reports is the best solution, however if the reports are based on separate packages, then combining them won't be an option. Well... It will, but you would have to use handwritten SQL and that is (almost) never a good thing.
Alternatives that I've given my clients are:
- Using event studio to send the results of all of the reports in a single email.
- Exporting all reports into a folder, then triggering a process to use a third party tool to combine the PDFs.
- Building a new package which combines the data from the disparate systems.
Hi Friends,
FYI
We had a conference with IBM staffs few days back.
So the feature I was looking for has been developed and is available in Cognos Report Studio 10.2.1.1 It's called "Report Booklets"
Regards
Slim