Automatic update of fields - Reporting Services
-
Hello,
I'm currently working on a Java Project to generate the XML of an SSRS Report, without using Report Builder (this project writes the XML of a report to an .rdl file).
I'm stuck on the Datasets part of my project. I provide a query to my Dataset and when I open my report, my Dataset is created but the fields are not displayed.
And When I execute my report, I have an error that tells me a problem with my DataSet.
This error means "An error occured during local report processing".
The solution I found is to go to "properties of the dataset" and click on "Refresh fields".
"Actualiser les champs" means "Refresh Fields".
The list of fields is displayed and I can run my report without any problem.
So I wanted to know if it was possible to have the fields update automatically without going through the properties of the DataSet and without the action of the user ?
I have already tried to edit the "AutoRefresh" value of the report, without success.
Is there an option to make this happen or some way to run the script behind the button ?
P.S : I need to generate a hundred of Dataset, so my click on "refresh fields" of each Dataset is not viable.
Thank you for any help you can give me.
-
That might depend on the nature of the queries for your data sets and your version of Visual Studio. I'm pretty sure you are NOT going to be able to get away from that, as building a report pretty much requires it ALL the time. I do question, however, the need to build a hundred datasets for just one report. Makes no sense. There's only so much information a report user can possibly digest at one time, and feeding the user of such a report a hundred different sources of data is just not a good idea in any conceivable way.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply