sql server reporting services: reading values from a dataset -- urgent -- sql server reporting services

reading values from a dataset -- urgent

Sangfroid
8/12/2004 5:09:01 PM

sql server reporting services:

Hi

I have a dataset and there are 2 columns in the dataset : Name , ID

In the report Design I need to have a text box in which I need to get the
value of the Name where ID = 7.

Please tell me if this is possible!!!
and if Yes then how do I do it?

Thanks a lot in advance

Re: reading values from a dataset -- urgent

Ravi Mumulla (Microsoft)
8/12/2004 5:59:33 PM

A couple of options:

1. Create a dataset that returns this one row and add it to the textbox as
=Fields!Item.Value
2. If this is the first or last row that this dataset returns, use the
expression =First(Fields!Item.Value) or =Last(Fields!Item.Value)

--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view]