Burst the report with Multiple Tabs

[jahnavi]

Hello Gurus,

Please Help me in the Following Isssue

I have a report with Multiple Pages 1 page is total customer info and from 2 to 7 we have the Individual Customer Info. so total of 8 pages. This Info when I run in excel 2007 I am getting in 8 different tabs. Now my issue is How can I burst the report with Product type Means For the product type =Xyz I need to get the 8 tabs in excel and for the product type =abc 8 tabs in excel (For individual Product type need to get 8 tabs)

Pls Help me in This

Thanks,

[PRIT AMRIT]

Can you provide more info about how you have designed your Multiple pages report? I guess page 1-8 are based on different queries?

[jahnavi]

Thanks For your Reply Prit.. Yes its based on different queries

[srinu1253]

You can keep a prompt in the Promt page with Product list.When you run the report You will get Prompt related Data in Excel itself
Does this approach meaning ful..???

[PRIT AMRIT]

Have u created 8 different queries or you have created one master queries for 'total customer' and then created shortcuts from 'Total Customer' to create individual queries for 'Customer'

Pls have a look at the attached XML.

Here, 'All Country' is the Master Query without having any filter on Country. As you can see Beijing, Shanghai, Guangdong, Shenzhen r shortcut queries, which are derived from the master query. If you filter the master query, then all these derived shortcut queries will also be filtered.

In your case you can Create one master Query for 'Total Customer'. Then create 7 shortcut queries derived from your master query.

Add a filter to your master query 'Total Customer' i.e.
[ Product type]=? Product type ?

I have used 'Profit Center Name' in the example.

Rest follow the 'Burst' query also as demonstrated in the XML eg.

Assuming you have already did the required set up to Burst report to file location.

Now, in Cognos Connection create 'Report View' for each Product Type entry, as shown in the attached 'ReportViewcreation' doc.

Once you run the JOB, you should be able to find the excel output for each product type having 8 pages in your file location.

This is bit weird though, hope this helps you?

Thanks
P

[PRIT AMRIT]

pls find

[jahnavi]

Hi Prit,

Sorry for late reply. We tried in many ways but no luck...