Report Display format, based on user selection.

building reports webintelligence
1

Hi All,

I have a requirement

On the report, I have Drill Down, where the user will select by “Gas” or “Dollars $”.

Depending on the user selection, the display of the report should change.

Please check the format…

If Selected “Gas” then

Month Invoice

2/09 100
3/09 200

If Selected “Dollars $” then

Month Invoice

2/09 $100
3/09 $200

Even though the report format is same and a single Drill-Down, based on user selection, it should change.

Please suggest.

Thxs,
Suresh

suresh_srinivasan (BOB member since 2009-03-25)

2

Suresh,

This may be done by SDK.
Could not found any work around in webi.

Satya Vooturi :india: (BOB member since 2009-01-15)

3

Use a variable,

=If (Userresponse() = "GAS"; Month Invoice; "$"+Month Invoice")

try this and see if this helps.

Cheers,

[Moderator Edit: Added code formatting - Jansi]

shiva.tomar (BOB member since 2007-10-05)