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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics