Mat Stephen's SQL Server WebLog

All things SQL Server. Complied by Matthew Stephen - SQL Server Product Specialist, Microsoft UK

Blogs

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

  • Comments 7
  • Likes

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
  • 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?

  • 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.

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

  • 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?

  • 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!

  • Very good commentaries

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