Hi all,
i have a list report with the following columns
PROJECT_ID PROJECT_NAME APR MAY JUN JULY AUG SEPT OCT NOV DEC
i have a prompt for period i.e. 1 to 12 for months.
if i select period prompt as '5' it should give me the output as PROJECT_ID PROJECT_NAME APR MAY and hide columns after may.
similarly when i select period prompt as '6' it should give me the output as PROJECT_ID PROJECT_NAME APR MAY JUN and hide columns after June.
We are using a relational datasource.
Request you to guide me with the same.
Regards.
Looks like a good candidate for render variables...
Hi BigChris,
could you please give me an example for the same ?
Thanks in advance!
Quote from: Raghuvir on 13 Jun 2014 09:07:24 AM
Hi BigChris,
could you please give me an example for the same ?
Thanks in advance!
The Report Studio User Guide details this - take a look at page 373.
http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.1/ug_cr_rptstd.pdf
Cheers!
MF.
Quote from: Raghuvir on 13 Jun 2014 06:48:23 AM
Hi all,
i have a list report with the following columns
PROJECT_ID PROJECT_NAME APR MAY JUN JULY AUG SEPT OCT NOV DEC
i have a prompt for period i.e. 1 to 12 for months.
if i select period prompt as '5' it should give me the output as PROJECT_ID PROJECT_NAME APR MAY and hide columns after may.
similarly when i select period prompt as '6' it should give me the output as PROJECT_ID PROJECT_NAME APR MAY JUN and hide columns after June.
We are using a relational datasource.
Request you to guide me with the same.
Regards.
Hi dude,
My first thought in your case is to create a variable per period because for each period you get a different action on your report.
for instance for May , create a boolean type variable with your condition (prompt period = 5). then select your list. select the variable u just created pick yes . apply it .
so when your condition is set as yes select June, July column ........ until Dec and select Box type in your property pane and set it as none. Normally it's supposed to work for May , repeat this action for the others month. Hope I made myself clear ;)
Quote from: bbtresoo on 13 Jun 2014 10:16:12 AM
Hi dude,
My first thought in your case is to create a variable per period because for each period you get a different action on your report.
for instance for May , create a boolean type variable with your condition (prompt period = 5). then select your list. select the variable u just created pick yes . apply it .
so when your condition is set as yes select June, July column ........ until Dec and select Box type in your property pane and set it as none. Normally it's supposed to work for May , repeat this action for the others month. Hope I made myself clear ;)
Thanks for the input.
i tried the steps u have suggested here but its not fulfilling my requirement.
i can just apply one render variable to the list. so i m confused how will i do it for the rest of the months except may.
Regards
You aren't trying to apply the conditional statement to the LIST. You want to apply it to the list column:
select the header of the column you want to hide
in the parentage selector (the little arrow above the properties pane), select list column.
Apply your render variable to the whole column..
Makes the sense?
Let us know how it goes...
Quote from: Raghuvir on 16 Jun 2014 03:04:08 AM
Thanks for the input.
i tried the steps u have suggested here but its not fulfilling my requirement.
i can just apply one render variable to the list. so i m confused how will i do it for the rest of the months except may.
Regards
Hi
Did u manage to do something? Here is a link to know a to deal with conditional
https://www.youtube.com/watch?v=hk74GC8IqJg
Come back to me if u're still stucked