Crystal Reports inputting values into report by selecting records

Message

   Hello guys,

I am having an issue while putting data in my crystal report based on my data set and was wondering if you could help.

basically i have got a dataset which looks something like below

Name     Value
A             10
B             15
C             20

I want to create a field by a select query to get the value where name is "A" which is 10 and then put this field into the report.

Then i ll create another field with a select query where name is "B" to get the value 15 and put that field in report.

so i have two fields @Avalue and @Bvalue

using select expert i can create one where condition on one field for the entire report. but here i need different conditions for different fields.

Not sure if there is any other way

Thanks very much