COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: gatorfe on 16 Oct 2007 10:49:44 AM

Title: Drill through on multiple selections possible?
Post by: gatorfe on 16 Oct 2007 10:49:44 AM
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.