Default Current Date in Prompt

building reports webintelligence
1

Hi There,

I want to display in my report by default as display Today’s date. And also have to choose required date as well while refresh the report.

I tried no. of ways but not getting.

Thanks in Advance

Shravan

shravan_bo :india: (BOB member since 2006-04-25)

2

I thought they were supposed to add the ability to have a default be a variable instead of just a constant in 4.2, but I don’t see it.

craiggsmith (BOB member since 2009-06-01)

3

In 4.2, you can use a formula as the default value for a parameter. You have to use IDT, not UDT. Create a parameter, either at the data foundation or business layer, check the option to set default values and then use a formula, i.e. CurrentDate() to set the default to today. You then use the parameter as part of your date filter in the BL.

dtolley (BOB member since 2006-07-14)

4

Here’s a very old post

that might be useful

mikeil (BOB member since 2015-02-18)

5

Thanks very much, I see that now. I was hoping we could just use a field in the universe as the default.

craiggsmith (BOB member since 2009-06-01)