November 20, 2009 at 8:10 am
I'm currently developing reports locally with the Report Builder application as well as in Visual Studio 2005. Unfortunately, our current server hosting plan with GoDaddy does not support reporting services and therefore, we are unable to host and manage reports on the ReportServer.
Being a relative newbie to the Reporting Services world, I'm wondering what my options are now as far as linking to reports (.rdl or .rdlc) through our Web site. I'm sure more details are needed to assist me, but I'm not sure what specific questions I need to be asking right now.
Any help would be much appreciated.
November 20, 2009 at 8:20 am
Reporting services is just a .net application that will run on any server with IIS and is installed as any other application.
Do they have a reason for not supporting reporting service? and do they host other .net applications for you?
November 20, 2009 at 8:38 am
Steve Irwin (11/20/2009)
I'm currently developing reports locally with the Report Builder application as well as in Visual Studio 2005. Unfortunately, our current server hosting plan with GoDaddy does not support reporting services and therefore, we are unable to host and manage reports on the ReportServer.Being a relative newbie to the Reporting Services world, I'm wondering what my options are now as far as linking to reports (.rdl or .rdlc) through our Web site. I'm sure more details are needed to assist me, but I'm not sure what specific questions I need to be asking right now.
Any help would be much appreciated.
Report Builder is an end user application for the users to build their reports so it is a clickonce application which is Windows form application not created for web deployment. If you are not using hosted SSRS it is not practical to expect the end user tool as part of a hosted service.
However if you have the SSRS license you can deploy it locally because it require Windows authentication by default which makes it local intranet application not a web hosted application. The other option is to use Reports in a web application without SSRS you have to SQL Server Express with Advanced Services it comes with the toolkit edition which can create simple Reports in local mode without SSRS. The first link is the SQL Server Express with Advanced Services and the second link is samples reports code. If you are in SQL Server 2005 make sure you use the SQL Server 2005 version it comes with Sp3 Post again if you still need help.
http://www.gotreportviewer.com/
Kind regards,
Gift Peddie
November 20, 2009 at 9:23 am
Gift Peddie (11/20/2009)
Steve Irwin (11/20/2009)
I'm currently developing reports locally with the Report Builder application as well as in Visual Studio 2005. Unfortunately, our current server hosting plan with GoDaddy does not support reporting services and therefore, we are unable to host and manage reports on the ReportServer.Being a relative newbie to the Reporting Services world, I'm wondering what my options are now as far as linking to reports (.rdl or .rdlc) through our Web site. I'm sure more details are needed to assist me, but I'm not sure what specific questions I need to be asking right now.
Any help would be much appreciated.
Report Builder is an end user application for the users to build their reports so it is a clickonce application which is Windows form application not created for web deployment. If you are not using hosted SSRS it is not practical to expect the end user tool as part of a hosted service.
However if you have the SSRS license you can deploy it locally because it require Windows authentication by default which makes it local intranet application not a web hosted application. The other option is to use Reports in a web application without SSRS you have to SQL Server Express with Advanced Services it comes with the toolkit edition which can create simple Reports in local mode without SSRS. The first link is the SQL Server Express with Advanced Services and the second link is samples reports code. If you are in SQL Server 2005 make sure you use the SQL Server 2005 version it comes with Sp3 Post again if you still need help.
Thanks for your reply Gift Peddie,
When you say "local mode", what exactly do you mean? The reports I've developed use stored procedures from the database hosted by GoDaddy, and they also contain parameters that the user will need to define before running the report in the web application. Based on the descriptions I've read within the links you provided, I'm not sure the toolkit will suit my needs.
Forgive my ignorance, since as I said, I'm relatively new to this whole process.
November 20, 2009 at 9:58 am
I think you can use the local mode because if your reports are not SSRS features dependent then you can use the Visual Studio ReportViewer control. Check below for more about the control and how to configure it in local mode. And if you create the reports with the control in local mode then you can just deploy it to the Godaddy server as just a web control.
http://msdn.microsoft.com/en-us/library/ms251671.aspx
Kind regards,
Gift Peddie
November 20, 2009 at 10:17 am
Okay, I'll play around with a sample report in local mode and see if the route you suggested is appropriate. I'll likely have more questions along the way.
Thanks so much for your help!
November 20, 2009 at 11:26 am
Steve Irwin (11/20/2009)
Okay, I'll play around with a sample report in local mode and see if the route you suggested is appropriate. I'll likely have more questions along the way.Thanks so much for your help!
I am glad I could help, post again if you still need help.
Kind regards,
Gift Peddie
November 20, 2009 at 3:41 pm
Gift Peddie (11/20/2009)
I think you can use the local mode because if your reports are not SSRS features dependent then you can use the Visual Studio ReportViewer control. Check below for more about the control and how to configure it in local mode. And if you create the reports with the control in local mode then you can just deploy it to the Godaddy server as just a web control.
I've created a sample report with the control in local mode. Now can you elaborate on deploying to the server as a web control? I'm not exactly sure what that means and what steps are involved.
Thanks again
November 20, 2009 at 4:03 pm
Here is a link that covers the deployment the main things to know it is a httphandler which means you need to register it in your Web.Config. Check the SSRS config files you could just copy that info to your Web.Config. I will look when I find I will post.
http://msdn.microsoft.com/en-us/library/ms251723(VS.80).aspx
In IIS7 how to add the httphandler in Web.Config have changed check below for how to add it.
http://otkfounder.blogspot.com/2007/11/solving-reportviewer-rendering-issue-on.html
Kind regards,
Gift Peddie
December 3, 2009 at 9:35 am
Thanks to the help on this board, I was able to get my report working on my local IIS server. Now, I'm struggling trying to incorporate parameters into my report. Essentially, I'm trying to do the same thing as the author of this article:
http://www.codeproject.com/KB/webforms/ReportViewer.aspx
The author states "If you are not using Microsoft Application Block, just call the stored procedure via the SQL Command object without using the SQL Helper class in the example."
I am not using the Microsoft Application Block, so I need help forming the SqlCommand code to call the stored procedure. Using the code from the article, could someone please offer up suggestions on how to incorporate the SQL Command?
Thanks again!
December 3, 2009 at 11:46 am
Steve Irwin (12/3/2009)
Thanks to the help on this board, I was able to get my report working on my local IIS server. Now, I'm struggling trying to incorporate parameters into my report. Essentially, I'm trying to do the same thing as the author of this article:http://www.codeproject.com/KB/webforms/ReportViewer.aspx
The author states "If you are not using Microsoft Application Block, just call the stored procedure via the SQL Command object without using the SQL Helper class in the example."
I am not using the Microsoft Application Block, so I need help forming the SqlCommand code to call the stored procedure. Using the code from the article, could someone please offer up suggestions on how to incorporate the SQL Command?
Thanks again!
It is not very complicated check the link below and go to the advanced section and you will see how to use stored procedures it may not include parameters but others will show how to use parameters.
http://www.asp.net/learn/data-access/
Kind regards,
Gift Peddie
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply