Report Designer
-
Hi,
I am currently looking at how to implement Reporting Services and I am confused.
Apart from having a Report Server in my MSSQL Server do my report developer team need to install developer edition on each of their PC in order to start with report creation? It would be a totally different installation files right?
Please advise.
-
Yes, they should install developer edition. This basically lets them have their own server to develop and test on prior to publishing the reports to your test and prod servers.
Theoretically, anyone with notepad and a penchant for writing raw XML could create reports (ie no visual studio and gui etc) but you'd be crazy (or like waaay geeky and trying to prove a point to your friends) to develop this way.
Steve.
-
Visual Studio is one of the hidden expenses of Report Services. Unless your shop skimps on licenses (it's very common), it can get expensive. Don't forget the extra SQL Server licenses if you plan to deploy portions on a separate IIS server.
From what I've seen so far, using Visual Studio is not appropriate for typical report developers, so we're sticking with Crystal Reports (it has its quirks) for a few more releases until Microsoft makes it a little easier and a little less expensive.
-
I agree re: the cost invovled. The line that I hear most used is buy VB.net (~$99 US or less per seat). This gets you the VS environment within which to start development.
You can of course use Cizer's web-based report writing (and delivery) suite Cizer Report.net (or something similar in name), then you don't require VS at all and *anyone* can author reports. Lastly, if you were to splurge on a single VB seat, when 2K5 comes out you could develop and deploy a Report Builder catalog and then anyone (with .net framework 2 on their machine) could write their own reports and deploy these to the RS server.
Steve.
-
It looks like SQL Server 2005 comes with the development environment, it's called business intelligence development studio.
-
thanks you guys.. i'm clear now..
-
The page at: http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
shows that BI Development Studio is available with the standard and enterprise editions of the database. Express and workgroup get just the report designer without the OLAP and data-mining features.
This is good news, though we'll have to give it three or four months of evaluation before we attempt to do anything in production with it.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply