cnetrdlcreport
I am creating RDLC report with two datasets. Earlier i was using one dataset and it was working fine,but when i added second dataset it started giving me following error for textboxes.
Error 1 The Value expression for the text box ‘Textbox10’ refers to the field ‘HospitalAddress’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope.
Why is this happening? Please help….
When you create a table in a RLDC, in the Tablix properties (selecting a row or a column) you must associate a DataSet.
After doing that, you have to write in each cell the name of the field (in the dataset) that you will use. You can do that by clicking on the "little table" in the cell, when you put the mouse over it
In images (with Visual Studio 2010)
If you don't see the dataset in the list, you must add it.
For that, click on view menu -> report data.
Then, in the DummyDataSource, click Add Dataset..
And select it from the list, or create a new one instead, in the same form.
If this doesn't work, well I don't know haha
If the two datasets has the same structure, then you could use one just, and in the code assign it to the datasource
Ah. Got it. There's no limit (atleast I haven't hit it yet).
If you have a div container that's not really defined (height/width) then its not going to work. An arbitrary height and width should do it!
Best Answer
You need to specify which dataset to use in your expressions now. Sample expression syntax below: