Saturday, February 25, 2012

Newbie - Good Doumentation Needed

Our current environment consists of a SQL 2000 server and report server with reporting services. I hope I didn't screw that up but I guess the important thing is, I'm sure it's SQL 2000. I have Visual Studio 2005. I need to edit existing reports on the report server website and create new reports with what I have. I am familiar with writing reports in a report viewer and I am familiar with SQL queries. I need some good documentation to get me started, and I'm having trouble finding it related to SQL 2000/VS2005. I dont have the foggiest of ideas of how to get VS2005 to see my exisitng reports and to get them to hook up with each other. Any advice to get me out the door would be much appreciated. Thanks!!

you can't creat Bi project in VS2005 as long as you don't install the MS Reporting service 2005 but you can create the BI project in VS2003 and just refere to the deployed reports on the reporting server

http://<machine name>/reportserver and use them in your VS2005 web or windows project by report viewer

|||

Since upgrading SQL and SQL reporting services to 2005 is out of the question at this point, does this mean I either need to get Visual Studio 2003 or I'm dead in the water?

Sounds like I'm stuck with my current setup. Correct?

|||

yes you need Visual studio 2003 and create BI project , develop yoour reports then deploy them on the reporting server so you can easily view them in your web or windows application using report viewer control.

No comments:

Post a Comment