Please help with this Value prompt

[richiearora]

Hi All,

Sorry for writting way too many queries on this Forum, But would really appreciate.

I am preparing this new OLTP report.

In My Data Source i have this Table of which one Query item have Values ("1,2,3,4,5,6,7,8).

All this values signifies some Thext Say 1- Yellow, 2- Red, 3-Green.

Now i am Creating a value prompt with List Box Choises, In which i will display the values, Red, Blue < Green..and so on.

I am sure we have this Function to use USE Value and Display values ..

But Not sure about the whole procedure to implement this on my report.

I want to know the Step by Step Process from Creating prompt , Query and Filter to report.

So that i can apply the Filter also to my queries accordingly.

Basically my report will Fetch records based on the Value Supplied, that is Red Blue Green...

Thanks a Lot For help

[Gopinath]

Create a calculated data item like

if([source data item] = 1) then 'Yellow' else
if([source data item] = 2) then 'Red' else
if([source data item] = 3) then 'Green'....

set the above data item as Display value for your value prompt, and the [source data item] as Use value


for filter use [source data item] = ?List_Prompt?

[richiearora]

Hi gopi,

I did Exactly the Same, However the Values are not Listed in the List Box :(

Please help..

It gives me Blank,


Do i need to Add them in Collection properties?

or Do i need to use Conditional Formatting by any chance?

Regards,
Richie

[PRIT AMRIT]

Seems your filter is:

[Calculated Item]=?List_Prompt?

Instead

Your filter should be: [source data item]=?List_Prompt?

and you should use [Calculated Item] in your list box for display purpose.

Hope this helps?

Thanks
Prit

[Gopinath]

In My Data Source i have this Table of which one Query item have Values ("1,2,3,4,5,6,7,8).

what is the datatype of your source filed? if it is varchar then, try

trim(cast([source data item] as varchar(3)))

[richiearora]

In the Filter Usage I have to use?

[Source Data Item] = ?Prompt Paramater name? 

Please help