If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Burst report containing multiple queries

Started by htimsluap, 17 Apr 2009 03:15:59 AM

Previous topic - Next topic

htimsluap

If I have a report containing multiple queries, each filtered by a common parameter, is it possible to burst the report based on all possible values for the parameter?

e.g a Great Outdoors report with multiple lists & charts based on separate queries, each filtered by Product Line Code, and I want a separate report for Product Line Codes 1, 2, 3, 4 & 5.

nonooo

hi

1/ define a query with your parameter
2/ add this query to a pageset
3/ add master-detail instead of parameter in your original page
4/ define the bursting on the new query
5/ enjoy the debugging :)


narutikas

Thank's for the tip. This stuff works at my c8.4. You can think it as of the page set passing parameter values to the next inner level, which are the actual queries forming your report.  Let's assume that you want to distribute a sales report to sales managers. You want to include one crosstab and a table. Maybe a graph. Normally RS would tell you that crosstabs wont fly etc. Now you create a page set wit your burst query (eg. sman name) as query. Put your report to the page set.  Then you create a parameter with sman name in your report queries and set it optional, otherwise it wont fly. Then you define burst options with burst query to the left and content query with your burst recipient to the right. Use sman name to link master detail relationship. Also see that other queries are linked with master detail rship.