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

Hey Issue on Showing summerized values in the report.

Started by ranne_78, 05 Oct 2006 02:40:15 PM

Previous topic - Next topic

ranne_78

Hey,

We created a report in Report studio and I grouped on Project name query item . when I ran the report it is giving both detailed values as well as summarized values as follows


projectname   profit  revenue   cost

AA              12        13     222\------detailed values
                   1        14        225/------detailed values
total           13        27     447-------summrized values



but as per our requirement it has to display as follows

projectname   profit  revenue   cost


AA          13        27     447  ------summarized values only for that particular group in single line

When I enable the aggregation as total it is displaying total for that grouped query item in multiple
lines but I want it in single line as  mentioned above.

How can I solve this issue.



MFGF

Hi,

Assuming ProjectName is the only non-measure item in your report, and you have Auto Group and Summarize turned on, you should get the result you are looking for without having to group manually on ProjectName.

If I were you I would go to the properties of the query and check that the Auto Group and Summarize property is set to 'Yes'.  If it is, then there is something else odd going on - probably best to look in Framework Manager at the properties of the Query Items you are using.

Let us know what you find.

Regards,

MF.
Meep!