Monday, March 26, 2012

Newbie Question

I've just started messing around with SQL2K5 and Reporting Service. I loaded SQL Server Reporting Pack for IIS. I can't seam to find any detailed details on the pack. Is there an easy way to repoint the 12 reports from the template db to my live IIS ODBC db? Or is it better to just start from scratch and build the reports?

Thanx

I'm not quite sure what you mean here? Are you saying you have 12 reports pointing to your old DB and now you want to point them to your new db? If so just change the datasource of the reports to your new db.

Make sure however the new db has the same table/column names as the datasets already in the reports otherwise the reports will break.

No comments:

Post a Comment