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

Default Date Prompt Issue

Started by caravapally, 15 Apr 2009 06:37:06 AM

Previous topic - Next topic

caravapally

Hi Everyone,

I have a dashboard report. In the dashboard report I've various reports (Chart, Lists, crosstab reports).

I have date prompt (the date prompts is showing in the report page), based on date selection I'll get the data.

In this report data items I used date parameter name.

In the output when I select one date from date prompt the output should be displayed with the whole week.

data item:

case
when (_day_of_week(?Date?, 6)=1)
then (_add_days(?Date?, 0))
when (_day_of_week(?Date?, 6)=2)
then (_add_days(?Date?, -1))
.....end

except these data times, I kept as optional(in all filters).

when I execute the report (From Report Studio or Cognos Connection) the date calendar is showing before getting the output, however users don't want this

my requirements is:

when they execute the report the report should be displayed the output directly with current date.

Please help me how can I resolve this...

Thanks,