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 to multiple reports

Started by ribru, 31 Dec 2020 04:23:36 AM

Previous topic - Next topic

ribru

Report has, a.o., one query-item "Category". It displays several categories, e.g. A, B, C.
I want to drill-through for this item, but: for each category to a seperate, dedicated report with details. So a separate report for A, a separate report for B etc.
In the page-design it is only possible to drillthrough on this item to one report.
Is it possible to drill-through to multiple reports (if category = A then to report X, if category = B then to report Y etc.) and if so, how?
Thanks in advance for your solution.

dougp

Why different reports?  That seems like a maintenance hassle.  Why not one report with a Category parameter?

dougp

If you truly need that functionality, you should be able to do it with an HTML item:

'<a href="https://servername/ibmcognos/bi/?pathRef=.my_folders%2F' || [Sales (query)].[Branch].[City] || '&amp;format=HTML&amp;Download=false&amp;prompt=true" target="_top">' || [Sales (query)].[Branch].[City] || '</a>'

Start by getting the "share" link for the target report.

ribru