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.

1. Rdlc Parameters

Rdlc Parameters

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? I managed to get this working (for SSRS in C# using a Dataset that points to a Stored Procedure) by:.

hitting Shift+Alt+D (which opens the ' Data Sources' window). In Data Sources, select/click the table you want to update. At the top of the window there are icons (I'm using VS2012). The 2nd from the right is ' Configure Data Source' - click it and it will open a new wizard window that will appear to be refreshing everything. UN-check the column that is no longer applicable and/or check the new column (if the values aren't already checked/unchecked). Go back to your ' Report Data' window (Ctrl+Alt+D) and right-click on your Dataset and then click ' Refresh'.

How can the answer be improved?

All the columns should be updated at that point.

Hello Yuvaraj D. Thanks for answering. He was looking at the example, and as I see your.rdlc file, you have a query parameter where there also and I imagine there get data for the report.

AdventureWorks2008R2 =Parameters!StateProvinceCode.Value SELECT soh.SalesOrderID, soh.TotalDue, soh.OrderDate, c.CustomerID, st.Name AS Store. In my case, I get the data from a stored procedure, I have it in a dataset. InterventoriasDataSet /. Local Query./ I thought I could do a global query, and from this, make a filter with parameters. Hello Yuvaraj D. First, sorry for not express myself well, I'm using google translator. LOL I try to explain very well.

For the generation of my reports, I am using a DataSet, where TablaAdapter added through stored procedures. Then I believe my report and select the DataSet and TableAdapter that previously believed. And the report is displayed correctly. Now, I want you to report that displays, adding a 'filter'. The TableAdapter brings me NEXT information. For example, I want the report has a filter by ' idSubCapitulo '. Where out a list of data that has that field my TableAdapter and can select the item and view the report.

Enclosed is my report RLCD Thank you very much.