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

Split part of a report in new report

Started by RudiHendrix, 21 Jul 2010 05:19:46 AM

Previous topic - Next topic

RudiHendrix

Currently I'm working on a new report. This report should be saved to a file location, there it will be picked up by Microsoft Biztalk and Biztalk prepares it to be displayed in Microsoft Sharepoint. No issues there. The saving is clear.

Now, in my report I have a chart and a list object. Both items are displayed per Contract. This results in a long list of Contracts with a chart and a list per contract. However, the guy from Sharepoint would like to have a separate report per Contract.

Sometimes we have 10 contracts in the result set, sometimes 100. I cannot know upfront how many reports need to be created.

Does somebody here have an idea?

imts

I think Bursting would be the way to go here . Set Contract_ID as ur burst key - shud do the trick.

-TS

mvjcognos

S bursting is the correct option............... :)

RudiHendrix

Thanks for the quick replies!

Ok...just to be on the safe side...

I have looked up bursting in the help file and I am adding that to the report. I have also checked the "Bursted Sales Performance Report". In there they have a Data Item containing [ManagerID]+'@grtd123.com'
So I thought I just add a Data Item and insert my own E-mail address.

If I then run the Run --> View tabular data it returns the following error:

PDS-PPE-0104
A record was rejected. An arithmetic overflow occurred. PDS-PPE-0104 A record was rejected. An arithmetic overflow occurred. (Data)

Can this be the case because I try to burst a report with a chart in it? I ask this because the documentation states: "You cannot burst crosstab reports."



RudiHendrix

Thanks for the answers! Bursting was indeed the solution!

For the fact that I wanted to burst a report with a chart in it I found this:
http://www-01.ibm.com/support/docview.wss?uid=swg21341874

Now it works like a charm!

Still I have to solve the other issue that I posted :)

RudiHendrix

I have one additional question for this one.

In the technotes on how to burst a crosstab I see the following step:
"8. Click on the row section of the crosstab (Order Method in the example provided). In the properties pane under Data, open the Properties dialog and click on the box for the burst key so it is checked."

I don't really understand this step.

In a chart, should I do this for all data items? Or just the ones on the x-axis or the y-axis?
What does this step do?

So, I have a list with the burst key in the first column (which is later on moved to a section), the chart in the second column and another list in the third column. Should I perform this step for a nested list as well?

Well...it's obvious... I don't understand what the properties setting does... :)