Passing static user inputs into the Report

building reports webintelligence
1

Hi Guys,
I have one report user wants to see prompts value where user can enter numeric integar values (X). based on these values i hve to calculate one field value in report.
For example : Resultant value ®= tableA.Column1 * X

step1: How should i create X as prompt which is not coming from database tables. its just dummy and blank field where user can plugin the integer values

Step2: how to calculate R values based on X values in Report.

suggestion are greatly appreciated.

Thanks
PV

sownu (BOB member since 2009-08-27)

2

Hi,

You can create a predefined condition in the universe in a format like this:

@prompt('select number','N',,mono,free) = @prompt('select number','N',,mono,free)

As you can see, the condition is always true so it will not affect data fetched from the database.

Then to get the value of the prompt on a report level, use UserResponse() function.

Marek Chladny :slovakia: (BOB member since 2003-11-27)