I am working on an intranet web application and there are some reports required, I never done reports before and I don't know how to display in web page, am I supposed to retreive the data from the database and dump it for example through label controls on
a web page or is there is something else more professional?
SQL Reporting services has a web interface. Take the URL for your report and place it in an iframe (the src) within your application. You will need to look up the syntax for passing parameters to your report.
The ReportViewer component just wraps this functionality for you to make it easier to pass parameters programmatically in an OO manner. If you are going to be doing many reports and want them to be easily maintained I'd use ReportViewer. Which by the way
comes with reporting services, check the Samples folder.
One more question please, which is easier to use for someone who never used any reporting tool before, Crystal Reports or SQL Server Reporting Services. All I need is 2 reports but they are not simple ones, which one I can have a quick start in it and easily
learn?
if you've used access reports before, i'd say go with reporting services. If you have an oracle data source tho, i'd suggest looking at alternatives because RS can be a bit of a nightmare working with SQL. I'd say tho that RS would probably be easier to just
start working with, however the online tutorials etc that are around can be a bit limited in terms of covering advanced topics. Also get used to using IIF() statements.
Crystal is big money, if you have SQL 2K, reporting services is free. With both you are going to have to sit down and learn how they work, especially if your reports are complex. Crystal is feature rich while with RS you have to do a lot of custom coding to
get things done on complex reports.
JessyEzzy
Member
315 Points
102 Posts
Reports in Web Application
Sep 04, 2005 04:18 PM|LINK
Thanks in advance.
n1patrick
Member
62 Points
16 Posts
Re: Reports in Web Application
Sep 05, 2005 11:05 AM|LINK
JessyEzzy
Member
315 Points
102 Posts
Re: Reports in Web Application
Sep 05, 2005 07:11 PM|LINK
Do you mean that I put the report viewer in an iframe?
I found a CrystalReportViewer control in the toolbox, is that what you're talking about?
n1patrick
Member
62 Points
16 Posts
Re: Reports in Web Application
Sep 06, 2005 08:38 AM|LINK
SQL Reporting services has a web interface. Take the URL for your report and place it in an iframe (the src) within your application. You will need to look up the syntax for passing parameters to your report.
The ReportViewer component just wraps this functionality for you to make it easier to pass parameters programmatically in an OO manner. If you are going to be doing many reports and want them to be easily maintained I'd use ReportViewer. Which by the way comes with reporting services, check the Samples folder.
There are tutorials on the web, search google- http://www.odetocode.com/Articles/128.aspx for example.
lomaxx
Member
380 Points
76 Posts
Re: Reports in Web Application
Sep 06, 2005 10:07 AM|LINK
JessyEzzy
Member
315 Points
102 Posts
Re: Reports in Web Application
Sep 06, 2005 05:16 PM|LINK
One more question please, which is easier to use for someone who never used any reporting tool before, Crystal Reports or SQL Server Reporting Services. All I need is 2 reports but they are not simple ones, which one I can have a quick start in it and easily learn?
Thanks.
patrick24601
Participant
1185 Points
260 Posts
Re: Reports in Web Application
Sep 06, 2005 10:04 PM|LINK
Information Technology Solutions
Helping You Focus. Helping You Succeed.
lomaxx
Member
380 Points
76 Posts
Re: Reports in Web Application
Sep 07, 2005 03:10 AM|LINK
n1patrick
Member
62 Points
16 Posts
Re: Reports in Web Application
Sep 07, 2005 10:18 AM|LINK
JessyEzzy
Member
315 Points
102 Posts
Re: Reports in Web Application
Sep 07, 2005 10:00 PM|LINK