Unable to refresh dataset in (rdlc) report
-
I'm using a stored procedure (proc) for the SqlDataSource1 of my local report (rdlc). I've changed my proc to include an additional field. When I try to edit my local report to add the new field, it does not show up in the dataset or fields under the expression buider. How do I get the dataset to recognize my new field. :~
-
I'm using a stored procedure (proc) for the SqlDataSource1 of my local report (rdlc). I've changed my proc to include an additional field. When I try to edit my local report to add the new field, it does not show up in the dataset or fields under the expression buider. How do I get the dataset to recognize my new field. :~
Yes.. this is really a problem with rdlc console. I think you need to clear the existing dataset from the report to continue. Right click on rdlc report -> Open With Xml Editor After you open find <Dataset> and remove its content. Now open the report, add any field to the report, your dataset will be added again with all the fields. (You can also update the report xml with your new field) Note: Before you do, backup your existing dataset to avoid corrupt of the report. :rose:
Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->** Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript -
Yes.. this is really a problem with rdlc console. I think you need to clear the existing dataset from the report to continue. Right click on rdlc report -> Open With Xml Editor After you open find <Dataset> and remove its content. Now open the report, add any field to the report, your dataset will be added again with all the fields. (You can also update the report xml with your new field) Note: Before you do, backup your existing dataset to avoid corrupt of the report. :rose:
Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->** Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript -
I edited the xml, which solved the problem. Your the best. Thank You very much. :thumbsup:
Thank you so much... Cheers. :thumbsup:
Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->** Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript