This might be designed behaviour, but it's doing my head in. I've got a report showing a number of graphs with things like the number of helpdesk calls for each user. I've then got a drill through report that's used as a target for several reports. On the target report there's an optional report to select either Open, Resolved or Both using static choices. Since most users want to see the open calls, I've got a default selection on that prompt of "Open".
In my source report I've created a field in my query which I've populated with the string "Both". No matter what I try I can't make the target report take the value of "Both"...it keeps using the default selection of "Open".
Am I missing something obvious? Am I just fighting a losing battle? Any help or suggestions would be gratefully received.
Cognos 10.2 / relational model / SQL server 208 r2
Quote from: BigChris on 19 Mar 2015 09:56:35 AM
This might be designed behaviour, but it's doing my head in. I've got a report showing a number of graphs with things like the number of helpdesk calls for each user. I've then got a drill through report that's used as a target for several reports. On the target report there's an optional report to select either Open, Resolved or Both using static choices. Since most users want to see the open calls, I've got a default selection on that prompt of "Open".
In my source report I've created a field in my query which I've populated with the string "Both". No matter what I try I can't make the target report take the value of "Both"...it keeps using the default selection of "Open".
Am I missing something obvious? Am I just fighting a losing battle? Any help or suggestions would be gratefully received.
Cognos 10.2 / relational model / SQL server 208 r2
Hi,
Is the field in question (in the source report) contained within the reporting object you are drilling from? If not - even if it is in the query - you can't pass it as a data item in the drill-though since it is not a value you are selecting. You could try populating a parameter with the value and passing the parameter - that ought to work?
Cheers!
MF.