Partager via

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

  • Article

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

  • Anonymous
    January 01, 2003
    From the blog hits I received the last time I posted some info on free report packs available for SQL...
  • Anonymous
    February 15, 2005
    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?
  • Anonymous
    February 15, 2005
    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.
  • Anonymous
    February 15, 2005
    We are using MS CRM 1.2, so I should be able to point the reports to the CRM server?
  • Anonymous
    February 16, 2005
    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?
  • Anonymous
    February 18, 2005
    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!
  • Anonymous
    February 22, 2005
    Very good commentaries