473,387 Members | 1,549 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,387 software developers and data experts.

RDLC vs. Crystal Reports

I am currently using ASP.Net 2003 and will be upgrading to 2005
sometime in the near future. I have been having issues with using
Crystal Reports that were included with .Net to handle my reporting
needs. I was wondering if anybody has an opinion on how the new
reportViewer control works in comparison to Crystal. One of the main
problems I have been having with Crystal Reports is that they seem to
load very slow no matter how small the report is and no matter how fast
the server is. I also have been having a problem (and I think this is
a Crystal bug) with creating the report to work with lets say the pubs
database. Then when I transfer to a different machine and want to use
a different database name pubsTest, the report fails. The application
that we are writing will have about 50 -100 people using it (not all at
once). One of my concerns with crystal was that I believe it has a
limit on how many people can run reports. Is this the case with RDLC?
Are RDLC faster? More reliable? Easy to use?

Jun 21 '06 #1
9 8209
the answer it's easy for the CR part.

Microsoft Visual Studio 2005 have the component for Crystal Reports under
ASP.NET, but this license is only for developer proposes, to have it under a
publishing server you need to buy a new license and as you can see under CR
website, does not have any limitation like the Developer license in the
VS2k5.

SQL Report Services is the same deal... under VS is only for developing...

Read more:
http://www.businessobjects.com/produ...ng.asp#webapps

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@g10g2000cwb.googlegr oups.com...
I am currently using ASP.Net 2003 and will be upgrading to 2005
sometime in the near future. I have been having issues with using
Crystal Reports that were included with .Net to handle my reporting
needs. I was wondering if anybody has an opinion on how the new
reportViewer control works in comparison to Crystal. One of the main
problems I have been having with Crystal Reports is that they seem to
load very slow no matter how small the report is and no matter how fast
the server is. I also have been having a problem (and I think this is
a Crystal bug) with creating the report to work with lets say the pubs
database. Then when I transfer to a different machine and want to use
a different database name pubsTest, the report fails. The application
that we are writing will have about 50 -100 people using it (not all at
once). One of my concerns with crystal was that I believe it has a
limit on how many people can run reports. Is this the case with RDLC?
Are RDLC faster? More reliable? Easy to use?

Jun 21 '06 #2
I know I read somewhere that Crystal can be used for up to a couple
users concurrently for web server purposes. Once you get past that
then you need to get Crystal Report Server. All of the documentation I
have read on RDLC and the reportviewer says nothing about having to get
a license for that.
As quoted from http://www.gotreportviewer.com/

# Q: Is a SQL Server license required to use the ReportViewer control?

A: No. The ReportViewer control is freely redistributable. It can work
independently of SQL Server ('local mode') and a SQL Server license is
not required. In remote mode the ReportViewer control talks to a Report
Server. The Report Server does require a SQL Server license.

Bruno Alexandre wrote:
the answer it's easy for the CR part.

Microsoft Visual Studio 2005 have the component for Crystal Reports under
ASP.NET, but this license is only for developer proposes, to have it under a
publishing server you need to buy a new license and as you can see under CR
website, does not have any limitation like the Developer license in the
VS2k5.

SQL Report Services is the same deal... under VS is only for developing...

Read more:
http://www.businessobjects.com/produ...ng.asp#webapps

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@g10g2000cwb.googlegr oups.com...
I am currently using ASP.Net 2003 and will be upgrading to 2005
sometime in the near future. I have been having issues with using
Crystal Reports that were included with .Net to handle my reporting
needs. I was wondering if anybody has an opinion on how the new
reportViewer control works in comparison to Crystal. One of the main
problems I have been having with Crystal Reports is that they seem to
load very slow no matter how small the report is and no matter how fast
the server is. I also have been having a problem (and I think this is
a Crystal bug) with creating the report to work with lets say the pubs
database. Then when I transfer to a different machine and want to use
a different database name pubsTest, the report fails. The application
that we are writing will have about 50 -100 people using it (not all at
once). One of my concerns with crystal was that I believe it has a
limit on how many people can run reports. Is this the case with RDLC?
Are RDLC faster? More reliable? Easy to use?


Jun 21 '06 #3
still, you need SQL 2005 Server w/Report Service licenced in a server
machine to run it.

can't use the free MSDE :-(

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@i40g2000cwc.googlegr oups.com...
I know I read somewhere that Crystal can be used for up to a couple
users concurrently for web server purposes. Once you get past that
then you need to get Crystal Report Server. All of the documentation I
have read on RDLC and the reportviewer says nothing about having to get
a license for that.
As quoted from http://www.gotreportviewer.com/

# Q: Is a SQL Server license required to use the ReportViewer control?

A: No. The ReportViewer control is freely redistributable. It can work
independently of SQL Server ('local mode') and a SQL Server license is
not required. In remote mode the ReportViewer control talks to a Report
Server. The Report Server does require a SQL Server license.

Bruno Alexandre wrote:
the answer it's easy for the CR part.

Microsoft Visual Studio 2005 have the component for Crystal Reports under
ASP.NET, but this license is only for developer proposes, to have it under
a
publishing server you need to buy a new license and as you can see under
CR
website, does not have any limitation like the Developer license in the
VS2k5.

SQL Report Services is the same deal... under VS is only for developing...

Read more:
http://www.businessobjects.com/produ...ng.asp#webapps

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@g10g2000cwb.googlegr oups.com...
I am currently using ASP.Net 2003 and will be upgrading to 2005
sometime in the near future. I have been having issues with using
Crystal Reports that were included with .Net to handle my reporting
needs. I was wondering if anybody has an opinion on how the new
reportViewer control works in comparison to Crystal. One of the main
problems I have been having with Crystal Reports is that they seem to
load very slow no matter how small the report is and no matter how fast
the server is. I also have been having a problem (and I think this is
a Crystal bug) with creating the report to work with lets say the pubs
database. Then when I transfer to a different machine and want to use
a different database name pubsTest, the report fails. The application
that we are writing will have about 50 -100 people using it (not all at
once). One of my concerns with crystal was that I believe it has a
limit on how many people can run reports. Is this the case with RDLC?
Are RDLC faster? More reliable? Easy to use?

Jun 21 '06 #4
I still use my reports in a standard HTML + CSS style, and they work great
:-) even in multiple pages (of course I need to calculate when do I want
page break, but still... pretty and clean ;-)

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@i40g2000cwc.googlegr oups.com...
I know I read somewhere that Crystal can be used for up to a couple
users concurrently for web server purposes. Once you get past that
then you need to get Crystal Report Server. All of the documentation I
have read on RDLC and the reportviewer says nothing about having to get
a license for that.
As quoted from http://www.gotreportviewer.com/

# Q: Is a SQL Server license required to use the ReportViewer control?

A: No. The ReportViewer control is freely redistributable. It can work
independently of SQL Server ('local mode') and a SQL Server license is
not required. In remote mode the ReportViewer control talks to a Report
Server. The Report Server does require a SQL Server license.

Bruno Alexandre wrote:
the answer it's easy for the CR part.

Microsoft Visual Studio 2005 have the component for Crystal Reports under
ASP.NET, but this license is only for developer proposes, to have it under
a
publishing server you need to buy a new license and as you can see under
CR
website, does not have any limitation like the Developer license in the
VS2k5.

SQL Report Services is the same deal... under VS is only for developing...

Read more:
http://www.businessobjects.com/produ...ng.asp#webapps

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@g10g2000cwb.googlegr oups.com...
I am currently using ASP.Net 2003 and will be upgrading to 2005
sometime in the near future. I have been having issues with using
Crystal Reports that were included with .Net to handle my reporting
needs. I was wondering if anybody has an opinion on how the new
reportViewer control works in comparison to Crystal. One of the main
problems I have been having with Crystal Reports is that they seem to
load very slow no matter how small the report is and no matter how fast
the server is. I also have been having a problem (and I think this is
a Crystal bug) with creating the report to work with lets say the pubs
database. Then when I transfer to a different machine and want to use
a different database name pubsTest, the report fails. The application
that we are writing will have about 50 -100 people using it (not all at
once). One of my concerns with crystal was that I believe it has a
limit on how many people can run reports. Is this the case with RDLC?
Are RDLC faster? More reliable? Easy to use?

Jun 21 '06 #5
still, you need SQL 2005 Server w/Report Service licenced in a server
machine to run it.
To me it doesn't look like you do, as I stated in the previous message

As quoted from http://www.gotreportviewer.com/

# Q: Is a SQL Server license required to use the ReportViewer control?

A: No. The ReportViewer control is freely redistributable. It can work
independently of SQL Server ('local mode') and a SQL Server license is
not required. In remote mode the ReportViewer control talks to a Report
Server. The Report Server does require a SQL Server license.

I have not seen anywhere stating that you must have SQL server but I
have seen almost everywhere saying that you do not need SQL server.
Yes you would need it if you use RDL, but I will be using RDLC.
Bruno Alexandre wrote:
still, you need SQL 2005 Server w/Report Service licenced in a server
machine to run it.

can't use the free MSDE :-(

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@i40g2000cwc.googlegr oups.com...
I know I read somewhere that Crystal can be used for up to a couple
users concurrently for web server purposes. Once you get past that
then you need to get Crystal Report Server. All of the documentation I
have read on RDLC and the reportviewer says nothing about having to get
a license for that.
As quoted from http://www.gotreportviewer.com/

# Q: Is a SQL Server license required to use the ReportViewer control?

A: No. The ReportViewer control is freely redistributable. It can work
independently of SQL Server ('local mode') and a SQL Server license is
not required. In remote mode the ReportViewer control talks to a Report
Server. The Report Server does require a SQL Server license.

Bruno Alexandre wrote:
the answer it's easy for the CR part.

Microsoft Visual Studio 2005 have the component for Crystal Reports under
ASP.NET, but this license is only for developer proposes, to have it under
a
publishing server you need to buy a new license and as you can see under
CR
website, does not have any limitation like the Developer license in the
VS2k5.

SQL Report Services is the same deal... under VS is only for developing....

Read more:
http://www.businessobjects.com/produ...ng.asp#webapps

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@g10g2000cwb.googlegr oups.com...
I am currently using ASP.Net 2003 and will be upgrading to 2005
sometime in the near future. I have been having issues with using
Crystal Reports that were included with .Net to handle my reporting
needs. I was wondering if anybody has an opinion on how the new
reportViewer control works in comparison to Crystal. One of the main
problems I have been having with Crystal Reports is that they seem to
load very slow no matter how small the report is and no matter how fast
the server is. I also have been having a problem (and I think this is
a Crystal bug) with creating the report to work with lets say the pubs
database. Then when I transfer to a different machine and want to use
a different database name pubsTest, the report fails. The application
that we are writing will have about 50 -100 people using it (not all at
once). One of my concerns with crystal was that I believe it has a
limit on how many people can run reports. Is this the case with RDLC?
Are RDLC faster? More reliable? Easy to use?


Jun 21 '06 #6
I have done that in some cases but I need the capability to export to
pdf.
Bruno Alexandre wrote:
I still use my reports in a standard HTML + CSS style, and they work great
:-) even in multiple pages (of course I need to calculate when do I want
page break, but still... pretty and clean ;-)

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@i40g2000cwc.googlegr oups.com...
I know I read somewhere that Crystal can be used for up to a couple
users concurrently for web server purposes. Once you get past that
then you need to get Crystal Report Server. All of the documentation I
have read on RDLC and the reportviewer says nothing about having to get
a license for that.
As quoted from http://www.gotreportviewer.com/

# Q: Is a SQL Server license required to use the ReportViewer control?

A: No. The ReportViewer control is freely redistributable. It can work
independently of SQL Server ('local mode') and a SQL Server license is
not required. In remote mode the ReportViewer control talks to a Report
Server. The Report Server does require a SQL Server license.

Bruno Alexandre wrote:
the answer it's easy for the CR part.

Microsoft Visual Studio 2005 have the component for Crystal Reports under
ASP.NET, but this license is only for developer proposes, to have it under
a
publishing server you need to buy a new license and as you can see under
CR
website, does not have any limitation like the Developer license in the
VS2k5.

SQL Report Services is the same deal... under VS is only for developing....

Read more:
http://www.businessobjects.com/produ...ng.asp#webapps

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@g10g2000cwb.googlegr oups.com...
I am currently using ASP.Net 2003 and will be upgrading to 2005
sometime in the near future. I have been having issues with using
Crystal Reports that were included with .Net to handle my reporting
needs. I was wondering if anybody has an opinion on how the new
reportViewer control works in comparison to Crystal. One of the main
problems I have been having with Crystal Reports is that they seem to
load very slow no matter how small the report is and no matter how fast
the server is. I also have been having a problem (and I think this is
a Crystal bug) with creating the report to work with lets say the pubs
database. Then when I transfer to a different machine and want to use
a different database name pubsTest, the report fails. The application
that we are writing will have about 50 -100 people using it (not all at
once). One of my concerns with crystal was that I believe it has a
limit on how many people can run reports. Is this the case with RDLC?
Are RDLC faster? More reliable? Easy to use?


Jun 21 '06 #7
but who runs the service??? right?

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@g10g2000cwb.googlegr oups.com...
still, you need SQL 2005 Server w/Report Service licenced in a server
machine to run it.
To me it doesn't look like you do, as I stated in the previous message

As quoted from http://www.gotreportviewer.com/

# Q: Is a SQL Server license required to use the ReportViewer control?

A: No. The ReportViewer control is freely redistributable. It can work
independently of SQL Server ('local mode') and a SQL Server license is
not required. In remote mode the ReportViewer control talks to a Report
Server. The Report Server does require a SQL Server license.

I have not seen anywhere stating that you must have SQL server but I
have seen almost everywhere saying that you do not need SQL server.
Yes you would need it if you use RDL, but I will be using RDLC.
Bruno Alexandre wrote:
still, you need SQL 2005 Server w/Report Service licenced in a server
machine to run it.

can't use the free MSDE :-(

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@i40g2000cwc.googlegr oups.com...
I know I read somewhere that Crystal can be used for up to a couple
users concurrently for web server purposes. Once you get past that
then you need to get Crystal Report Server. All of the documentation I
have read on RDLC and the reportviewer says nothing about having to get
a license for that.
As quoted from http://www.gotreportviewer.com/

# Q: Is a SQL Server license required to use the ReportViewer control?

A: No. The ReportViewer control is freely redistributable. It can work
independently of SQL Server ('local mode') and a SQL Server license is
not required. In remote mode the ReportViewer control talks to a Report
Server. The Report Server does require a SQL Server license.

Bruno Alexandre wrote:
the answer it's easy for the CR part.

Microsoft Visual Studio 2005 have the component for Crystal Reports
under
ASP.NET, but this license is only for developer proposes, to have it
under
a
publishing server you need to buy a new license and as you can see under
CR
website, does not have any limitation like the Developer license in the
VS2k5.

SQL Report Services is the same deal... under VS is only for
developing...

Read more:
http://www.businessobjects.com/produ...ng.asp#webapps

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@g10g2000cwb.googlegr oups.com...
I am currently using ASP.Net 2003 and will be upgrading to 2005
sometime in the near future. I have been having issues with using
Crystal Reports that were included with .Net to handle my reporting
needs. I was wondering if anybody has an opinion on how the new
reportViewer control works in comparison to Crystal. One of the main
problems I have been having with Crystal Reports is that they seem to
load very slow no matter how small the report is and no matter how
fast
the server is. I also have been having a problem (and I think this is
a Crystal bug) with creating the report to work with lets say the pubs
database. Then when I transfer to a different machine and want to use
a different database name pubsTest, the report fails. The application
that we are writing will have about 50 -100 people using it (not all
at
once). One of my concerns with crystal was that I believe it has a
limit on how many people can run reports. Is this the case with RDLC?
Are RDLC faster? More reliable? Easy to use?

Jun 21 '06 #8
NH
you do not need a SQL licence to use the ReportViewer control. You dont need
Reporting services to use it either. YOu feed datasets to the control and
that is how the report is built.

"Bruno Alexandre" wrote:
I still use my reports in a standard HTML + CSS style, and they work great
:-) even in multiple pages (of course I need to calculate when do I want
page break, but still... pretty and clean ;-)

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@i40g2000cwc.googlegr oups.com...
I know I read somewhere that Crystal can be used for up to a couple
users concurrently for web server purposes. Once you get past that
then you need to get Crystal Report Server. All of the documentation I
have read on RDLC and the reportviewer says nothing about having to get
a license for that.
As quoted from http://www.gotreportviewer.com/

# Q: Is a SQL Server license required to use the ReportViewer control?

A: No. The ReportViewer control is freely redistributable. It can work
independently of SQL Server ('local mode') and a SQL Server license is
not required. In remote mode the ReportViewer control talks to a Report
Server. The Report Server does require a SQL Server license.

Bruno Alexandre wrote:
the answer it's easy for the CR part.

Microsoft Visual Studio 2005 have the component for Crystal Reports under
ASP.NET, but this license is only for developer proposes, to have it under
a
publishing server you need to buy a new license and as you can see under
CR
website, does not have any limitation like the Developer license in the
VS2k5.

SQL Report Services is the same deal... under VS is only for developing...

Read more:
http://www.businessobjects.com/produ...ng.asp#webapps

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)
"Altman" <ba*****@easy-automation.com> escreveu na mensagem
news:11**********************@g10g2000cwb.googlegr oups.com...
I am currently using ASP.Net 2003 and will be upgrading to 2005
sometime in the near future. I have been having issues with using
Crystal Reports that were included with .Net to handle my reporting
needs. I was wondering if anybody has an opinion on how the new
reportViewer control works in comparison to Crystal. One of the main
problems I have been having with Crystal Reports is that they seem to
load very slow no matter how small the report is and no matter how fast
the server is. I also have been having a problem (and I think this is
a Crystal bug) with creating the report to work with lets say the pubs
database. Then when I transfer to a different machine and want to use
a different database name pubsTest, the report fails. The application
that we are writing will have about 50 -100 people using it (not all at
once). One of my concerns with crystal was that I believe it has a
limit on how many people can run reports. Is this the case with RDLC?
Are RDLC faster? More reliable? Easy to use?


Jun 21 '06 #9
dgk
On Wed, 21 Jun 2006 17:28:30 +0200, "Bruno Alexandre"
<br*********@gmail.com> wrote:
but who runs the service??? right?


A reportviewer control with ProcessingMode set to Local (which is what
RDLC means - C is Client) runs on the local PC and does not need SQL
Server. If ProcessingMode is set to Remote then it is running a report
that is part of SQLServer Reporting Services (an RDL report) and that
server must be running SQL Server.

In local mode, the programmer supplies the data to the report as
needed, with subreports requiring an event handler to supply the data.
That data can come from a local or remote database of any kind since
you can pass in business objects as easily as a datatable. Local mode
is limited to only being able to output the report as PDF or Excel.

I did this in a Windows project but I think it works the same way in a
web page.
Jun 22 '06 #10

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

Similar topics

5
by: BStorm | last post by:
I have a transaction log file where the DataSet table's Description column is actually delimited into "subcolumns" based upon the transaction id. I would like to parse these into separate fields...
3
by: Gheaci Maschl | last post by:
Hi all! I would like to have your opinion about my problem and my proposal how to solve it: Ingredients: - BTriev database - Crystal Reports - maybe MS Access - Liinos6 (small ERP software)
0
by: Robert Warnestam | last post by:
Hello, I have some problems deploying Crystal Reports. I'm using Visual Studio 2005 Beta 1. In this version Crystal Reports (9.7.3500.0) is included. I created a small test application...
3
by: VMI | last post by:
I know this may not be the best NG for this, but I feel you guys know more about this than any of the other NGs. I need to build several simple reports (over 50 of them and they get their data...
1
by: Lyners | last post by:
Hello all, I have created an ASP.NET website that uses Crystal Reports that works on the localhost (my PC), but when I copy it to the server it does not. The problem is...
1
by: foocc | last post by:
Hi, im trying to convert data reports (.dsr) in vb6 to crystal reports in vb.net. However, I cant seems to find it in my Microsoft Visual Studio 2005 Tools for Office. I've tried going to...
0
by: newkhan | last post by:
Hi, I have worked with RDLC reports on visual studio.net 2005 and now i am using crystal reports. I want to add data from single table using ado.net and in the crystal report I have added the...
3
by: Miro | last post by:
Hi, Just wondering what a good book is on visual studios 2008 ( or 2005 if no 2008 ) that teaches you how to properly use crystal reports with it. Or im assuming that as long as I can create a...
1
by: =?Utf-8?B?Q2lhcmFuIE8nJ0Rvbm5lbGw=?= | last post by:
On reflection, you could possibly make the app a self extracting zip file which extracts the EXE and a settings file and then starts the app, then when you app closes, it can repack the settings...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
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...

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.