If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to hide a column?

Started by lakshmi.crn, 03 Apr 2008 05:25:44 AM

Previous topic - Next topic

lakshmi.crn

Hi I have few queries,

How to hide a column in a report?
How to display todays data by default?
How to assign default value ?

Thanks,
Lakshmi

almeids

- In a list, select column, change Box Type property to None, repeat for header if any.  In a crosstab, filter out that column's dimension's lowest level data item's value.
- (assuming you have a date prompt) One way is to add a second prompt ?what_date? with static choices "Today" and "Select", default value "Today".  Make your date prompt and its filter optional.  Add a second filter (?what_date?='Today' and [date_column]=systemdate) where systemdate comes from a Cognos or database date function.
- If your default value is predictable or you can manipulate it to make it predictable, just set it in the Default Selections property of the prompt.  Otherwise, use Javascript in an html item.  You can find sample code on various forums for selecting the first value in a list as the default.

Rao

Hi Lakshmi,

By using Box type none ... we can hide a column.

Rgds,
Rao