Connecting Tech Pros Worldwide Forums | Help | Site Map

RDLC vs. Crystal Reports

Altman
Guest
 
Posts: n/a
#1: Jun 21 '06
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?


Bruno Alexandre
Guest
 
Posts: n/a
#2: Jun 21 '06

re: RDLC vs. Crystal Reports


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" <baltman@easy-automation.com> escreveu na mensagem
news:1150896253.438059.324730@g10g2000cwb.googlegr oups.com...[color=blue]
>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?
>[/color]


Altman
Guest
 
Posts: n/a
#3: Jun 21 '06

re: RDLC vs. Crystal Reports


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:[color=blue]
> 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" <baltman@easy-automation.com> escreveu na mensagem
> news:1150896253.438059.324730@g10g2000cwb.googlegr oups.com...[color=green]
> >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?
> >[/color][/color]

Bruno Alexandre
Guest
 
Posts: n/a
#4: Jun 21 '06

re: RDLC vs. Crystal Reports


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" <baltman@easy-automation.com> escreveu na mensagem
news:1150899101.546418.227050@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:[color=blue]
> 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" <baltman@easy-automation.com> escreveu na mensagem
> news:1150896253.438059.324730@g10g2000cwb.googlegr oups.com...[color=green]
> >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?
> >[/color][/color]


Bruno Alexandre
Guest
 
Posts: n/a
#5: Jun 21 '06

re: RDLC vs. Crystal Reports


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" <baltman@easy-automation.com> escreveu na mensagem
news:1150899101.546418.227050@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:[color=blue]
> 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" <baltman@easy-automation.com> escreveu na mensagem
> news:1150896253.438059.324730@g10g2000cwb.googlegr oups.com...[color=green]
> >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?
> >[/color][/color]


Altman
Guest
 
Posts: n/a
#6: Jun 21 '06

re: RDLC vs. Crystal Reports


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:[color=blue]
> 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" <baltman@easy-automation.com> escreveu na mensagem
> news:1150899101.546418.227050@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:[color=green]
> > 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" <baltman@easy-automation.com> escreveu na mensagem
> > news:1150896253.438059.324730@g10g2000cwb.googlegr oups.com...[color=darkred]
> > >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?
> > >[/color][/color][/color]

Altman
Guest
 
Posts: n/a
#7: Jun 21 '06

re: RDLC vs. Crystal Reports


I have done that in some cases but I need the capability to export to
pdf.


Bruno Alexandre wrote:[color=blue]
> 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" <baltman@easy-automation.com> escreveu na mensagem
> news:1150899101.546418.227050@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:[color=green]
> > 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" <baltman@easy-automation.com> escreveu na mensagem
> > news:1150896253.438059.324730@g10g2000cwb.googlegr oups.com...[color=darkred]
> > >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?
> > >[/color][/color][/color]

Bruno Alexandre
Guest
 
Posts: n/a
#8: Jun 21 '06

re: RDLC vs. Crystal Reports


but who runs the service??? right?

--

Bruno Alexandre
(a Portuguese in Københanv, Danmark)


"Altman" <baltman@easy-automation.com> escreveu na mensagem
news:1150903008.938997.297850@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:[color=blue]
> 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" <baltman@easy-automation.com> escreveu na mensagem
> news:1150899101.546418.227050@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:[color=green]
> > 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" <baltman@easy-automation.com> escreveu na mensagem
> > news:1150896253.438059.324730@g10g2000cwb.googlegr oups.com...[color=darkred]
> > >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?
> > >[/color][/color][/color]


NH
Guest
 
Posts: n/a
#9: Jun 21 '06

re: RDLC vs. Crystal Reports


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:
[color=blue]
> 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" <baltman@easy-automation.com> escreveu na mensagem
> news:1150899101.546418.227050@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:[color=green]
> > 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" <baltman@easy-automation.com> escreveu na mensagem
> > news:1150896253.438059.324730@g10g2000cwb.googlegr oups.com...[color=darkred]
> > >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?
> > >[/color][/color]
>
>
>[/color]
dgk
Guest
 
Posts: n/a
#10: Jun 22 '06

re: RDLC vs. Crystal Reports


On Wed, 21 Jun 2006 17:28:30 +0200, "Bruno Alexandre"
<bruno.in.dk@gmail.com> wrote:
[color=blue]
>but who runs the service??? right?[/color]

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.
Closed Thread


Similar ASP.NET bytes