473,395 Members | 1,941 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

SQL Server reporting services...

Has anyone used SQL Server Reporting Services to develop reports with using
vb .net ?? We are wondering whether or not to stick with Crystal (hence
purhcase the pro version of .net) or go with the SQL Server product (hence
go with teh cheaper standard .net product). I have not heard anything - good
or bad about the SQL server product...

Any input would be welcomed!

Thanks,

Brad
Apr 19 '06 #1
2 1107
BK
We are using SRS for some of our reporting needs, here is my take on
the results:

Pros:

It's easy to create reports, very easy. I spent a little time training
a quasi technical but mainly functional person and she was writing
reports in no time. She does all her work with the Web client, we
didn't install .Net on her machine (saved us a bunch of money!)

The users like the consistent and easy to understand interface to run
their reports

It reads the metadata in from SQL server when you create the data
model, so I didn't have to teach my power user anything about
relationships.

Cons:

The web client designer is limited.

If you make a change to the back end database schema, the model needs
to be regenerated.

We learned the hard way that it can be difficult or downright
impossible to recover a report sometimes if you make enough changes to
the back end.

HTH

Apr 19 '06 #2
Thanks for your input...

My co-worker just read an article that indicated that the product should be
installed on a differnt machine than the SQL server. Did you do this? It
made it seem like the product may be a bit of a pig on resources. The
download for it is huge (150mb).

So you can develop using a web client but it is limited. I can definately
see the pro there of saving money for sure - That may be fine for an enduser
doing ad hoc stuff - but not like comprehensive enough for any real serious
report development work I take it then??

Brad
"BK" <bk******@hotmail.com> wrote in message
news:11*********************@i39g2000cwa.googlegro ups.com...
We are using SRS for some of our reporting needs, here is my take on
the results:

Pros:

It's easy to create reports, very easy. I spent a little time training
a quasi technical but mainly functional person and she was writing
reports in no time. She does all her work with the Web client, we
didn't install .Net on her machine (saved us a bunch of money!)

The users like the consistent and easy to understand interface to run
their reports

It reads the metadata in from SQL server when you create the data
model, so I didn't have to teach my power user anything about
relationships.

Cons:

The web client designer is limited.

If you make a change to the back end database schema, the model needs
to be regenerated.

We learned the hard way that it can be difficult or downright
impossible to recover a report sometimes if you make enough changes to
the back end.

HTH

Apr 19 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: farrell77 | last post by:
What up-to-date books on this topic can people here recommend? Thanks. - Bob
1
by: GeekMarine1972 | last post by:
We are planning to deploy the MS Reporting Services. Unfortunately, there isn't much guidance on how to effectively size a server. Here are my questions: 1) In an environment with 1 reporting...
8
by: Woody Splawn | last post by:
I am asking this question here because I asked this question in the Reporting Services Newsgroup and did not get an answer. Does anyone know if Reporting Services is intended to work in a...
1
by: LeAnne | last post by:
I've got SQL Server 2000 Developer edition. Now, where can i get the SQL Server 2000 Reporting Serives from for Win XP Pro?? I can't seem to find a link or any page where I could download this...
16
by: Jeremy S. | last post by:
I'm about to install VS.NET 2005 and SQL Server 2005 on a new/clean development machine (XP Pro/SP2 etc). Is the order of installation important (i.e., which product should I install first)? ...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
1
by: yhafeez1 | last post by:
We are in the process of doing a side by side installation of the SQL server 2000 and SQL server 2005 on the same server. To install the Reporting services feature of SQL server 2005 requires IIS....
3
by: =?Utf-8?B?Sm9uIEphY29icw==?= | last post by:
We use SQL Server 2000 We user VS 2005 How can we use SQL Server reporting Services? Thanks,
0
by: fperri | last post by:
Hi, I am trying to configure reporting services which I just added to an already existing installation of SQL Server 2005. When I am in the reporting services configuration manager and I am trying...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.