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,