Hi ,
I need a help regarding chart report in Cognos Reportnet. I have a requirement in which we have to show user defined measures in chart report. The user should have flexibility to choose his own measures from prompt that needs to be displayed in the Chart report. I have created a prompt and added measure names as static choices, Now when user selects a perticular measure name in the prompt only those measure needs to be displayed in the chartb type. Please help me in resolving this issue
HI
Try this once may be it can help you.
For Mesure use a Calculated Data Item and give this in the Prompt
and use following code for calculated item
Case when ?pro1?=col1 then col1
when ?pro1?=col2 then col2
......
......
......
......
else colN(this is default mesure)
end
or
use default selection for prompt and use prompt in the same report page.
Try this May be it will work for u
Thanks
Sanjeev
Quote from: mynamesanju on 14 Sep 2007 07:13:20 AM
HI
Try this once may be it can help you.
For Mesure use a Calculated Data Item and give this in the Prompt
and use following code for calculated item
Case when ?pro1?=col1 then col1
when ?pro1?=col2 then col2
......
......
......
......
else colN(this is default mesure)
end
or
use default selection for prompt and use prompt in the same report page.
Try this May be it will work for u
Thanks
Sanjeev
Hi Sanju
This will not support multiple selection. I want to select multiple mesure selection.
Just let them use Query Studio ... ;D