Reporting Services, looking up data in another dataset

[Guggly]

Hi! I'm not sure if this is the right forum to ask a question regarding Reporting Services. If not, please redirect me.

I have a dataset that I'm basing a report on, which contains numeric data. In another dataset there are text descriptions for these values (i.e. 1=apple, 2=orange, etc.) Is there any way for me to do a lookup on the other dataset from an expression, or do I need to build this into the main dataset that I'm getting data from?

In other words if my main dataset has a record with the following data:

Name=John
Fruit=2

And I want "orange" to be displayed instead of "2" how can I do this? I've tried creating a lookup query in an expression but all that gets returned is the SQL string, DLookup doesn't seem to work either.

Any thoughts?

Thanks! -- Mike

 

[Pattycake245]

The query to pull the dataset will need to be modified to join the fruit descriptions dataset to the first dataset based on the fruit id.

select a.Name, b.Fruit
from table1 a join table2 b
on a.fruitid=b.fruitid

Tim

 

[Guggly]

Okay, so no way to lookup data in another dataset right? Thanks for your help!