SSRS Reporting assigning a value to the textbox

See more:

ASP.NET

SSRS

Hi All,

I have problem with assigning a value to the textbox in rdls report.

1. I have 2 columns in a report which displays the data for current and previous month or year. So columns are Current and Previous.

2. My datatable which is a datasource of the report returns 2 rows which has data for current year/month in First row and Previous year/month data in second row.

3. Back to report designing now, I have assigned a value to the current record like this : Field!ColumnName.Value And this works fine

Now problem comes here

How can I assign a second row to the Previous Data Column?

I hope my question is clear.

Thanks in advance.