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.
Why different reports? That seems like a maintenance hassle. Why not one report with a Category parameter?
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] || '&format=HTML&Download=false&prompt=true" target="_top">' || [Sales (query)].[Branch].[City] || '</a>'
Start by getting the "share" link for the target report.
Thank you