Hide List Columns Conditionally.

[Raghuvir]

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.

[BigChris]

Looks like a good candidate for render variables...

[Raghuvir]

Hi BigChris,

could you please give me an example for the same ?

Thanks in advance!

[MFGF]

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.

[bbtresoo]

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 ;)

[Raghuvir]

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

[MDXpressor]

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...

[bbtresoo]

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