Impromptu Sub-Reports 2

[toddl]

Hi,

I have a question on impromptu sub-reports. I have a total in a sub-report that I would like to add to a total in another sub-report and a few values on the main report to come up with a grand total. Is cognos capable of doing this, or is there a way to work around it?

Todd

 

[griffindm]

toddl,

Not possible in my experience. A sub-reports can take results from the main report, but not the other way around and certainly not from other sub-reports. Let me know if anyone has found a way around this.

Sorry,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[GJParker]

Todd

I'm in agreement with Dave on this one, Impromptu doesn't support what you require unfortunately.

A not very friendly workaround may be to calculate and save your subreport totals as hotfiles and link these into your main report.

without knowing more about your data structure and report requirements this may or may not be a possibility.

HTH

Another alternative would be to use a different reporting tool such as crystal reports which does allow this functionality.

Gary Parker
MIS Data Analyst
Manchester, England