Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

RDLC Report Data doesn't update to reflect changes

Tags:

On my RDLC page, the "Report Data" window shows a custom dataset that it pulls fields from to display. I've modified this DataSet with some additional tables. However, these tables aren't shown and therefore I'm unable to select them for use in expressions (in the Expression window, under Datasets, there are only the tables that were originally there, not the additional tables I've added).

Refreshing the data source doesn't do anything, and if I right-click on it and select "New Dataset", I'm unable to select the parent data source (it doesn't appear in the drop down list). What I mean is, if the data source is called "MyDataSet", and under that are other DataSets, if I right-click and go to "Add Dataset", it brings up the dialog box but "MyDataSet" is not in the list of available Data sources, even though I'm specifically saying I want to add a datatable to that data source. The other, existing, datatables list it under the data source, but new ones do not.

How do I refresh the data source so I can access these new tables in my report?

like image 439
Wayne Molina Avatar asked Jan 03 '11 18:01

Wayne Molina


People also ask

How do you refresh a DataSet in Rdlc?

In visual studio if you have the RDLC open you can open the Report Data window by pressing CTRL + ALT + D . From here you click on datasets and then right click on the data set to refresh it. Save this answer.

What is difference between RDL and Rdlc?

RDL and RDLC formats have the same XML schema. However, in RDLC files, some values (such as query text) are allowed to be empty, which means that they are not immediately ready to be published to a Report Server.


1 Answers

This is an old question, but I was having this problem too and I'll mention my answer for future googlers.

In the Report Data Window (which automatically appears for me when I am editing a .rdlc file), I had to Refresh my Dataset (same name as the DataSetName in the Tablix in my .rdlc Report), and then that updated the XML of the .rdlc file. The new fields are then available to me.

like image 91
Conrad Avatar answered Sep 28 '22 17:09

Conrad