February 28, 2007 at 10:25 am
I have Reporting Services installed and configured to be able to do some reporting against our Microsoft CRM site. (SQL Server 2000)
What tools to I need to install in order to get started learning how to write reports??
February 28, 2007 at 5:31 pm
Here's some suggestions:
- You'll need a good knowledge of the Microsoft CRM database structure, so you can create/use its tables, views and procedures.
- You'll need to create an OLE/DB or ODBC connection to the database (this will be your datasource in Reporting Services)
- I've been to the Microsoft Reporting Services course (2030) and highly recommend it. Alternatively there are a bunch of tutorials here:
http://msdn2.microsoft.com/en-us/library/ms170246.aspx
Try going through them.
February 28, 2007 at 5:43 pm
That all sounds good. thank you. I'm just having trouble getting started. don't I need visual studio to actually write the reports? not sure where to get my hands on it. i tried installing visual studio developer from our companies msdn cds without any luck..
February 28, 2007 at 8:29 pm
Ah yes...
If you have SQL 2000, you need a separate Visual Studio licence. You also need the Microsoft SQL Reporting Services media, which you must have to have instlled the server. From the media you can install the Reporting Services component into Visual Studio. You _might_ need a VS2003 install for SQL2000, but don't quote me on that.
If you have SQL2005, it includes a licence for "Report Studio", which is basically Visual Studio 2005 with the Reporting Services plugin.
We were able to get SQL2000/VS2003 to work together, and have upgraded to SQL2005.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply