Date Calander option in Infoview

building reports webintelligence
1

Hi ,

Could you please let me know how could you get the"Date Calender" displayed in your infoview adjacent to your date parameters? What did you do in report or universe to get this calender displayed??

We want users to choose from calender instaed of putting date manually?
Please help.

Uploading a file.Please refer the pic and tell me how this option can be obtained in DESKI reporting.I am using DESKI.
calender in Infoview.doc (35.0 KB)

CA_BO (BOB member since 2008-06-10)

2

Hi,
If you use a date object then it will give you the calendar option
Regards,
Kumar

kumar446 :india: (BOB member since 2006-01-23)

3

You posted in the Webi forum. :slight_smile:

Simply put: Deski does not offer the calendar option that Webi provides.

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

4

If your prompt object type is ‘D’ (date) then the calendar option will show up for Deski reports viewed via InfoView.

Is that correct Dave?

twenty5 (BOB member since 2008-01-22)

5

The object type of the object I have prompted as parameter is Date only.
But still I am not getting Calendar while running the report via infoview. :hb:

Please help…

CA_BO (BOB member since 2008-06-10)

6

Which version of Infoview your using?

I can see deski DATE format Objects are prompted with Calendar garget attached for date selection…

Also if it is a prompt, can you post the prompt definition?
Date Format with Calendar.doc (75.0 KB)

murali_Lagisetty :us: (BOB member since 2008-09-29)

7

I am using BO XI R2 Infoview. The prompt definition I am using in the report is =UserResponse (“Query 1 with Corporate_History_Universe” , “01. Begin Date”)

Corporate_history_universe is my universe name and the label for displayed date is 01. Begin Date.

While runnin in infoview it does not show up any calendar but only a text box, where I have to manually write the date.Please suggest.

CA_BO (BOB member since 2008-06-10)

8

What is the syntax of the @Prompt() in the universe. The UserResponse() function is used on the report to capture the selection. It does not have anything to do with the prompt creation / interface.

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

9

what you sent is not a prompt definition… it’s a variable definition used to fetch the user response for Query 1 with… and prompt 01. Begin Date. Please go to your universe, double click prompt 01. Begin Date. that is the prompt definition. Please send us that.

twenty5 (BOB member since 2008-01-22)

10

Ok. Now I am able to get this calendar prompt in Infoview :+1:
I re-do it and this time I used the “table.field” as the prompt definition in universe with datatype Date.

I think previously I was using some to_date and trunc functions for this prompt with date datatype only, but wonder why then it didnt work.Any suggestion?

CA_BO (BOB member since 2008-06-10)

11

But one more question guys, when I am running the report in infoview/DESKI for the first time it is not asking for any parameters and directly displaying the report, then on trying to run it again or on refresh it shows the parameters. But if I close it and again open and run, first time it does not show up parameters. why???

CA_BO (BOB member since 2008-06-10)

12

Whenever you click on the report…you are opening it.(so it does not show the prompts)…the last saved values are shown. But when you click refresh it again refreshes against the database.
If you want the prompts to appear when you click on it…do a Save As–>Refresh on Open.

Thanks,
Kon

konquistador :us: (BOB member since 2006-01-04)

13

Thanks. It worked. Thank you all of you who helped me get the solution.

CA_BO (BOB member since 2008-06-10)