Reporting Services : 21 Report packs released to the web for free download


Just incase you missed this freebie:


Report Packs


SQL Server 2000 Report Pack for Microsoft CRM
Download this set of six predefined CRM-based reports and a sample database that let you easily visualize and author managed reports to support key sales activities


 


SQL Server 2000 Report Pack for Microsoft Exchange
Download this set of 13 predefined Exchange-based reports and a sample database that let you easily visualize and author managed reports for e-mail administration


 


SQL Server 2000 Report Pack for Financial Reporting
Download this set of six predefined financial reports and a sample database that let you easily visualize and author managed reports to support key finance activities


 

Comments (7)

  1. Anonymous says:

    From the blog hits I received the last time I posted some info on free report packs available for SQL…

  2. Ian says:

    I had a look at the CRM reports and using SQL reporting for CRM is much better than using the Crystal, can you give me some pointers on using it with our real CRM data rather than the sample data and the same goes for the Exchange reports, how do you get the reports to run on the real data?

  3. Matthew Stephen says:

    The CRM database is very similar to the Microsoft CRM database. I can’t help you with your particular CRM package, except to say you’ll need to find a suitable OLEDB or ODBC provider to talk to it; you’ll need to speak to your vendor to help you with that.

    The Exchange report pack gives you a link in the readme to the vendors website where you can purchase, or trial an application to pump data out of exchange into the sample schema provided. Alternatively you can use ADO and the Exchange OLEDB provider to get the data yourself.

  4. Ian says:

    We are using MS CRM 1.2, so I should be able to point the reports to the CRM server?

  5. Matthew Stephen says:

    Thanks Ian

    From the readme,

    "You can use the sample reports as templates for designing new reports. With the reports in this pack, you can take the report definition files and, with only some minor configuration changes, have them work against your existing Microsoft CRM environment. If you choose to use these reports against your existing Microsoft CRM application, be aware that they bypass the Microsoft CRM application security layer and will require the user to have SQL access privileges to all views and tables in the Microsoft SQL Server database that contains the Microsoft CRM data.

    "

    So in prnciple the answer is yes – however I’m not sure exactly what changes are required. I don’t have MS CRM installed – perhaps you could give it a go and let us know how you get on?

  6. Ian says:

    Thanks for the tips, I have got it working by just changing the connection string.

    The hard part now is working out which fields to use.

    Great product!

  7. Byron-Paul Mayne says:

    Very good commentaries