How can i use a snapshot of a report to generate a file for another system i.e. drop in a file location
Hi Everyone,
I have a question about using a snapshot to recreate a report and then save that report as a csv to a file share on a network somewhere. Basically we have a DMS system and the users want to upload a report to a DMS - this is done by giving it a certain filename
and dropping it in a pick folder on the network.
My Initial idea was to create a new rendering enxtension so that when a user is happy with the report output they just 'export' it to the dms. This worked ok in that i am able to create the file in the pickup location but i wanted to customise the
response that went back to the client. I was hoping i could generate some html to say "document sent to dms, etc" and that would appear in the window which is spawned when i click export. However, i cant get control of the response object and so
the open / save dialog pops up with my html message with an actual .htm file :( ...
Firstly does anyone have a nice solution for the above hurdle i have? (i have already written a csv renderer which im modifying)
As i came stuck with the above i thought i could stick a button on the report labbeled 'send to dms' which would then take the snapshot ID (so data is the same as when the report ran - some data updates frequently and i DONT want to pick that up) of the
report that was run, re-generate it using the renderer web service or something and then do name the resulting file as needed and drop it in the DMS pick up location.
Hopefully ive explained what i am trying to achieve. Any ideas / or solutions to the above would be greatly appreciated,
Let me know if further info is needed.
Thanks :)
July 19th, 2011 12:33am
Hi Dave198026,
Based on the information you gave, here you want to customize rendering extension, I involve in somebody who familiar with this issue to
have a further look. There might be some time delay. Appreciate your patience. Thank you for your understanding and support.
Thanks,
Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2011 2:17am
Hello,
Please refer to the MSDN magazine for reference:
Display Your Data Your Way with Custom Renderers for Reporting Services
http://msdn.microsoft.com/en-us/magazine/cc163840.aspx
This probably does not take control of the response object but shows how we can display custom messages.
If you need to have access to the response object, I believe, the following KB shows how we can achieve this.
How to create a sample application that uses the Reporting Services SOAP APIs to render a report to a selected file format on a Web page
http://support.microsoft.com/kb/875447
Hope this helps.
Thanks.Meer Al - MSFT
August 14th, 2011 3:42pm
Hello,
Please refer to the MSDN magazine for reference:
Display Your Data Your Way with Custom Renderers for Reporting Services
http://msdn.microsoft.com/en-us/magazine/cc163840.aspx
This probably does not take control of the response object but shows how we can display custom messages.
If you need to have access to the response object, I believe, the following KB shows how we can achieve this.
How to create a sample application that uses the Reporting Services SOAP APIs to render a report to a selected file format on a Web page
http://support.microsoft.com/kb/875447
Hope this helps.
Thanks.Meer Al - MSFT
Free Windows Admin Tool Kit Click here and download it now
August 14th, 2011 3:42pm