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

Remove day from date prompt - list box

Started by cognosun, 17 Oct 2012 06:54:03 AM

Previous topic - Next topic

cognosun

Hi Gurus,

Is there any way to remove day number ( 1,2...31) from the Date prompt from the display.

We are using date prompt in the listbox.

Thanks in Advance,
Joys




tjohnson3050

Do you want to extract the day number from the date chosen, or do you want to only prompt for month and year?

cognosun

Yeah want to see only month and year in prompt.

Using value prompt we achieved it but is there any way using 'date prompt'.

As Cognos don't allow to edit data properties for date prompt.

pricter

Playing a little with the styles you may achieve that
For example with the following code placed it in a html item

<style>
.pd
{
visibility:hidden;
;
}
.pds
{
visibility:hidden;

}
.pw
{
visibility:hidden;
}
</style>


I have achieved the days not to be visible.

With the above you should take into consideration that the value of the prompt will be the current day + month and the year the uses has selected.

So you will have to manipulate the DateParameter in your query

cognosun

It's working offcourse but day number is again appearning in the edit box. We are not using calendar box

bdbits

When we want month/year-only selections for date ranges, we will sometimes use value prompt dropdowns with display values like "September 2012", "August 2012", "July 2012", etc. and use values appropriate to what is needed for a parameter or filter. We typically back them with a query that determines the valid date ranges to present based on what's in the database/cube.

Not necessarily slick looking, but it does the job for us.