Menu
SSRS dataset not refreshed after changing MySQL stored procedure.
I created an SSRS report in which the dataset gets data from MySQL stored procedure. In this scenario the output is generated correctly and so is the report.
Later I modify some content in the stored procedure. I run the stored proc in query designer. In query designer it gives the correct output.
But when going to report if I see the report in preview tab it gives old values. Changed are not coming in presenting report.
Please tell me what's wrong.
735
While creating any SSRS report using stored procedure, you will first create dataset for it. Select stored procedure in dropdown and click refresh fields.
In this article, we will show you how to create an SSRS Report using Stored Procedure with an example. It's one of the frequently asked questions by SSRS followers. To demonstrate the same, we are going to create a Stored procedure on the Adventure Works DW database.
Try deleting the MySolution\MyProject\MyRDL.data file -- BIDS caches fairly aggressively.
120
This is a bug in Visual Studio i think it happens to me as well. Usually closing the report in Visual studio and reopening helps.
36
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
