Is it possible to use shared datasources? I opened an existing RDL and is showed me the shared datasource, but when I tried to create a new dataset against it I got the error “Query Creation Failed”.
Aspose.Cells for Reporting Services does not support shared data sources.
Please check your Excel installed Microsoft query when getting the error “Query Creation Failed”. Using an existing RDL is one way process. Visual Studio can open RDL which is created by Aspose.Cells for Reporting Services. But it only gets base data information. And, it does not get style and Excel features.
OK, the error is due to the shared datasource then. Why on earth aren’t they supported? Unfortunately thats a fundamental maintainability issue for us…
And you features list says that you do support shared datasources "In addition to this, Aspose.Cells for Reporting Services supports both report specific data sources and shared data sources created on Report Server in advance."
Thanks for your posting and using Aspose.Cells for Reporting Services.
You are right. The product pages say that shared datasources are supported. So we will test shared datasources and update the pages accordingly.
First, Aspose.Cells for Reporting Services Client (Report Designer) supports to get the shared data source of report define file which is created by Visual Studio. But it cannot add new dataset or edit data set through shared data source because MS Query does not directly access data from data source of report define file.
If you find this error “Query Creation Failed”, please try following operation/ steps.
1. Select from Microsoft Query menu item and run Microsoft Query form.
2. Close and re-open Excel.
3. Add data source for Aspose.Cells for Reporting Services Client.
The feature is only used through Microsoft Query about adding data source and editing data set.
OK understood. So the million dollar question.
Please try our latest version/fix: Aspose.Cells for Reporting Services v126.96.36.199 (attached).
We have added new feature for changing data set without re-building the entire data set using MS Query.
Please try the latest version (attached) and refer to the following operations:
1. 1) Open report definition file with Aspose.Cells for Reporting Services Client in MS Excel.
2. 2) Click Build Data Set button (refer pic1).
3. 3) Select data set node and click edit button (refer pic2).
4) Update SQL command and click update button to update fields (refer pic3, pic4, pic5, pic6).