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
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?
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
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
Quote from: richiearora on 28 Feb 2011 09:40:59 AM
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)))
In the Filter Usage I have to use?
[Source Data Item] = ?Prompt Paramater name?
Please help