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

Drill through on multiple selections possible?

Started by gatorfe, 16 Oct 2007 10:49:44 AM

Previous topic - Next topic

gatorfe

I have a summary report set up with drill through capabilities to a detailed report.  In the prompt page of the summary report the user selects the company numbers they want to see the sales for during a time range.  The drill through icon on the summary report is the total sales value for the time range.  When they click on the sales value the detail report breaks down which company the numbers are coming from and other customer detail information.  The problem I am running into is that when I select multiple companies in the prompt page of the summary report and then drill down on the sales number I get only one company to show up on the detail report. Not the 2 or 3 that I choose in the prompt page of the summary report.  My parameters on the summary and detail report are set to look at [Sales Organization].[Company Code] in ?CompanyCode?.  Is it possible to send multiple selections thru a drill through? If so what step am I missing? Thanks in advance for any suggestions.