Displaying Prompt values in webi report

[Former Member]

Hi,

How to display prompt value in my webi report.

For one prompt value I can user Userresponse function.

In one of my report, I have a prompt for Date, which also should be displayed in the report under one field. I am using the below formula: =UserResponse("Enter Date:")

But my new requirement is User wants a Date Range for a particual trasaction date. I created a report level prompt like

Transaction Date Between "Enter Tran Date(Start):" and "Enter Tran Date(End):"

I need to display the start date and end date user selected under one field Date in my webi report.

how should I do that.

Please share your thoughts.

Thanks,

Ven Men

[Former Member]

Hi Ven,

You can display Start Date and End Date in one cell using the below formula

=UserResponse("Enter Tran Date(Start):") + " " + UserResponse("Enter Tran Date(End):")

Thanks,

Sandeep B. Singh

[Former Member]

Hi Ven,

You have created a report level prompt like

Transaction Date Between "Enter Tran Date(Start):" and "Enter Tran Date(End):"

1.Drag two blank cell on report.

2.click on one blank cell and on formula editor type following formula.

=UserResponse("Enter Tran Date(Start):" )

This will show you start date in the cell.

3.Similarly in another cell type the following formula

=UserResponse("Enter Tran Date(End):" )

This will show you End Date in respective cell.

Do revert in case of any queries.

Thanks,

Sandeep B. Singh

[Former Member]

Thanks for your reply Sandeep.

I want the values in one cell only. For example, if the user selects start date as 10/17/08 and end date as 10/21/08, these values should be displayed under one field(in once cell) as

10/17/08

10/18/08

10/19/08

10/20/08

10/21/08.

Thanks

[amrsalem1983]

hi ven

i got ur idea

UserResponse will only return the text that the user has wirtten for your prompts

if you need to have your requirment done as you want, why not you add the date object with the query it self, and then add it to the report

like

mydate between "prompt the user for a date start" and "prompt the user for a date end"

add this "mydate" in the result objects, and in turn add it to the report itself.

good luck

Amr

[Former Member]

amr,

Can you please elaborate how should I do that.

You mean to say I need to include date object in the query and the drag that date object in the report field.

I did that. I included date object along with other objects and also dragged that object in the report. I am not getting anything displayed in that field.

Thanks,

Ven Men

[amrsalem1983]

you are right, that i wat i was meaning,

to get the date object with the date itself in the result objects.

and then add this field to the report.

if you've data returned from the query then you should get a date returned, coz you are restricting the values for this date

try to make a new report tab, and drag the date field to there,, and check if it returns data or not,

good luck

Amr

[Former Member]

Thanks Amr. Its working. Previously there was no date for the date range I selected and that is the reson nothing was displaying in my report

[amrsalem1983]

good luck ven,, it was something easy