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

Concatinate paramter value and report counts

Started by BobaGreek, 20 Aug 2009 02:42:45 PM

Previous topic - Next topic

BobaGreek

Hello forum,

Is it possible to concatinate pramter value and report counts? For exaple, I have a report with multi-select Country prompt. A user wants to see the detail report and prompt information in the header along with country totals. For example user selects three countries: USA, France and Germany. In the report header they want to see the following:

USA (50), France (25), Germany (28)

The numbers are number of orders for a particular country. It's very simple task to display a prompt values, but how to concatinate counts makes me puzzle.

Thank you,

Boba

blom0344

The're 2 different things. Displaying a prompt value is part of a report expression, whereas showing totals is associated with a query. This would require 2 seperate objects positioned next to another which will give the impression in the output that they are one.
You can nest a table in a cel (header) list and show the totals there. I would simply take the query dataitem that holds the country and use this with the totals, instead of mixing prompt and query values