I would like some opinions on how you would deal with the following scenario:
We probably have somewhere from 500 to 1000 reports (written in crystal). We also have about 120 clients; each client has their own database.One of the reasons for so many reports is because a lot of our customers want report A but with this or that extra column added so we end up with a lot of custom versions of one report for a particular client.My question is in converting over to Reporting Services, how would you setup the file structure?
Right now, we are thinking that every client is going to have their own folder which would contain all Reports, Models, and Datasources.What do you guys think?
There is a feature called My Reports that you could use. This allows customers to keep their own versions of the reports in their own folders.
http://msdn2.microsoft.com/en-us/library/aa256334(SQL.80).aspx
No comments:
Post a Comment