calendar prompt

system · May 6, 2008, 1:08pm

Hi all, Can anybody tell me how to display calendar control in my date prompt in the webI report please?

thanks.

ramcste (BOB member since 2007-10-24)

system · May 6, 2008, 1:56pm

What version are you on?
In XIr2 you can arrange this by removing all the checkmarks at the prompt-properties (visible at the right of your prompt). Now users always have to use the calendar when selecting a date.

phonque (BOB member since 2005-10-17)

system · May 6, 2008, 9:35pm

Hi, thanks for your reply. I am using webI 6.x
I was able to display the calendar at the prompt. But I have another problem…
I have two fields for the date range at the prompt. Date From and Date To. With Calendar control, when I selected the date it displays the selected date and also “12:00:00 AM”
Is there any way that I could make it to show just the selected date? so that when Date From and Date To values are same, it should just treat as Date equal to.
With this “12:00:00 AM”, I cant achieve it unless I change the time 11:59:59.
Hope I was clear and thanks in advance.

ramcste (BOB member since 2007-10-24)

system · May 6, 2008, 9:52pm

That is just the way it works.

Dave Rathbun (BOB member since 2002-06-06)

system · May 7, 2008, 12:04pm

Hi ramcste,

could you tell me how to create Calendar prompt in Webi. I am also looking to create Webi Calendar prompt.

Advance Thanks.

Rohit27 (BOB member since 2008-03-03)

system · May 7, 2008, 12:41pm

Hi Rohit,
You need to do create this filter at universe level. here is the sample code:

TABLENAME.COLUMNNAME = @Prompt(‘Enter Date:’,‘D’,Mono,Free,user:45)

hope this helps.

ramcste (BOB member since 2007-10-24)

system · May 7, 2008, 1:29pm

Hi,

Thanks quick reply,

sorry, I am asking about Calendar popup box.

Adavance Thanks.

Rohit27 (BOB member since 2008-03-03)

system · May 7, 2008, 1:45pm

This should display calendar control on webi report on refresh. Try creating that filter in universe.

ramcste (BOB member since 2007-10-24)

system · May 7, 2008, 2:08pm

Hi

Are you getting this type box. Could please check below box.

Advance Thanks.

Rohit27 (BOB member since 2008-03-03)

system · May 7, 2008, 2:54pm

here is the screenshot of calendar control.

ramcste (BOB member since 2007-10-24)

system · May 12, 2008, 2:50pm

Hi

I have create filter on example universe but its not working.

I have create month object which is reference Calendar table but its not working.

could you tell me clearly…

Advance thanks.

Rohit27 (BOB member since 2008-03-03)