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
- 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.
Hi Lakshmi,
By using Box type none ... we can hide a column.
Rgds,
Rao