Exporting Reporting Services Report to a Sharepoint UNC
Hello, is there anyway to setup a report to export to a sharepoint UNC through the Report Manager without setting it to be integrated with Sharepoint in the RS settings? We currently have 2005 installed for both and when I go to the subscription and paste in the valid Sharepoint UNC, it says path not valid (after the report runs). I did some research and from what I read, it says you have to configure RS to be integrated with Sharepoint but my supervisor doesn't think so, so I wanted to confirm. He suggested going into the SQL Agent Job for that Report itself (it worns you about updating it) and adding a second step, a COPY sql command to copy the report from a non sharepoint site to the sharepoint site. I tested that and what I saw was, after the RS job ran, it deleted my second step in the job! Plus my sql copy command code is also saying the path is not valid when I test in query analyzer window. Maybe that is permissions related? But even if I could run this code in query analyzer window without incident, I do not have confidence that it would work after seeing my step 2 disappear. Sorry it was sort of a ramble but I hope it made sense. If anyone has insight into how to do this without setting up RS to be integrated, that would be great. My super said he does not want to set it up that way. Thank you
March 12th, 2011 5:14am

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

Other recent topics Other recent topics