Zack
asked on
SSRS Puzzle A question of Extraction and Automation
Hi EE,
This question is more of a query looking for approaches to resolve the following issue:
The user has an SSRS 2016 report and filters the datasets efficiently with filters they have been given.
However, the user wants to save specific rows within the report to key the data into another system e.g Desktop application. Exporting initial the result set data to XML result is a simple task. My question is can you have a button on the SSRS which launches a subform that asks what rows /columns specifically do you want to save from the resultset in XML format. Completing the necessary criteria on the subform, SSRS exports the data to the user via a download.
Is this possible in SSRS if so are there examples out there?
Any links or tips, advice are welcome.
Thank you.
This question is more of a query looking for approaches to resolve the following issue:
The user has an SSRS 2016 report and filters the datasets efficiently with filters they have been given.
However, the user wants to save specific rows within the report to key the data into another system e.g Desktop application. Exporting initial the result set data to XML result is a simple task. My question is can you have a button on the SSRS which launches a subform that asks what rows /columns specifically do you want to save from the resultset in XML format. Completing the necessary criteria on the subform, SSRS exports the data to the user via a download.
Is this possible in SSRS if so are there examples out there?
Any links or tips, advice are welcome.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER