Automating Report Deployment in Reporting Services in SharePoint Integration Mode Revisited

Comments

# Sylvia said on June 23, 2008 7:44 PM:

What about RSBuild on codeplex?

http://www.codeplex.com/Project/ProjectDirectory.aspx?ProjectSearchText=RSBuild

# shawnfel said on June 23, 2008 8:15 PM:

I built this for a client, i thought it was pretty useful.  i also had a lot of people ask questions about my samples.

just a couple of questions

Does RSBuild support RS in sharepoint integration mode (thats key)?

does it auto hookup all the data sources which never deploy correctly to the reports library?  

can it add columns to the SharePoint document library?

# Juergen said on July 7, 2008 7:30 AM:

Hi Shawn,

nice coding, thanks! Indeed I played a little bit with the solution you suggested in your former post and found it very useful - still I feel a little uneasy bypassing the Sharepoint layer when uploading. I am too insecure about the synchronization process between MOSS and the report server database.

My question: Does Microsoft encourage this way of report deployment via the ReportService2006.asmx when in Sharepoint integrated mode?

Thanks and cheers,

Juergen

# shawnfel said on July 7, 2008 11:08 AM:

Thx. Definitely appreciate your comments.  These are the APIs that are provided by the product team.  The fact that the web services are deployed within SharePoint should indicate that this is the ideal way to programattically upload reports.  When I initially wrote this code i posed alot of questions back to the internal distribution lists (that the product team is a part of) because it wasn't easy to figure out how to hook the reports back up to the datasources once they were uploaded.  I will say no one came out and said i shouldn't be accessing the Reports in this way.  Hope that helps.  

-shawn

# Gordon Duthie said on July 10, 2008 6:00 AM:

I've manage to deploy your solution and activate it to a sub site.

Firstly, I created a directory SamplesReportsLibrary, which i added all the Reports content types to.

I added the two columns, defined as required fields in the ReportsDefinition.xm file,

, ReportID and ReportCategory to the document library.  However, i still see no reports. Any idea where i'm going wrong?  

# shawnfel said on July 10, 2008 9:38 AM:

I probably didn't explain it that well, but the project will create the samplereportslibrary for you with the columns based on the reportsdefinition.xml file.  It will also add the content type.  So in the feature directory, does the reportorigination folder exist and does it have any reports in it?  Are there any errors in the event log? Have you been able to debug the code?  

Can you send me your feature directory in a zip file?  if you email me using this link http://blogs.msdn.com/feldman/contact.aspx.  i'll send you my email.  

Leave a Comment

Name (required) 

Your URL (optional)

Comments (required) 

  

Enter Code Here: Required

Remember Me?

About shawnfel