Possible not to show some columns?

[ratnalein]

Hallo everyone,

I have created a list report with 10 columns:

Date     Number of Dead People      Number of Alive People     Number of Sick People
------     ------------------------------      -----------------------------     ----------------------------


By creating a filter, I give the user to choose which kind of people they want to see, example:
"Sick People" is choosed:

Date     Number of Dead People      Number of Alive People     Number of Sick People
------     ------------------------------      -----------------------------     ----------------------------
01.01                    0                                           0                                    45674
02.01                    0                                           0                                        403


Is it possible to let the columns appearance depending to the filter the user choosed?  My ideal report for above example would be:

Date    Number of Sick People
------    ----------------------------
01.01                45674
02.01                    403

Thank you..

Regards,

Ratna   

[g.congnos]

Hi,

I don't think you can hide the column in a list.

If you use the crosstab instead of the list, you can do it using the suppression property.

[Lynn]

You can use a render variable to hide the columns in a list. You could also use an advanced conditional style.

[ratnalein]

Hallo Lynn and g.congnos,

thank you for the advice.  I tried to use the render variable, but it behaves very wierd:

Boolean Variable with this definition:
[Dim_ID] in '1'

[Hierarchy-Element].[ID] is definied in the filter, which can be selected by the report user.  In my case, I say: "if the user choose a particular ID, than take this ID.  If the user doesnt choose any ID, than assume all ID values as choosed" :

Code Select Expand


[Dim_ID] #promptmany('filter_id','varchar',' <> ' +sq('-'), ' in (','',')')#


It doesnt give me the correct hiding:
1.  If nothing is taken as filter(I tick nothing in the filter), it gives me all columns  --> this is correct
2.  If I tick a particular ID value, it gives me also all columns --> this is false

It is not easy to explain it without seeing the code.  I will just try to fix it.  The logic doesnt seem to work in my report.  I have done something wrong(I assume, the filter with promptmany is the problem). 

If you have any clues, please kindly comment.  Thank you.

Regards,

Ratna

[TheBrenda]

I followed this and it worked

http://www.ibm.com/developerworks/data/library/cognos/reporting/dynamic_report_design/page570.html

[ratnalein]

Hallo TheBrenda, Lynn, g.congnos,

thank your for your advices.  It worked finally  ;)

In my case, the clue was to define the render filter like this:

Code Select Expand


ParamDisplayValue('my_filter') contains 'my_ID_value'


Thank you..

Regards,

Ratna