November 21, 2008 at 6:18 am
I have been building reports for a couple of years for various web sites, and have always used the report builder and viewer that is part of VS 2005.
The latest web site that I am doing as a survey as one part of it. Several reports that are required for this survey needs like 7 queries, and I could not find any way with the report builder and viewer to build this report.
So I spent several weeks reading and studing reporting services, and now have it up and running. The customer is happy with assessment report of the survey data.
THE PROBLEM is this, now all the local reports are trying to login into the report server to run the report. The reports are not part of, and NOT located on the reports server!
So my question, can you use a mixture of local and remote reports on the same web site? Or, do I have to move all reports to the report server?
IF not, what is going on here and how can I fix it?
R Barbre
Software Engineer using VS 2005 & 2008
SQL Server 2000 DBA
November 24, 2008 at 6:06 am
Hi..R Barbre..
Gr8 to knw that you have started working on BIDS...ie..Business Intelligence Development Studio...
Actually..wat ever the reports we create using BIDS...to access them in our applications ...(as a web site in your case....), We need to deploy those on a report server...(it may be a local system or a remote server) and we can bind the same server URL to a report viewer control in order to access the concerned reports...:)..in our web page...
I hope..this should help you...:)
Thanks alot,
Niraj
November 24, 2008 at 6:21 am
Niraj (11/24/2008)
Hi..R Barbre..Gr8 to knw that you have started working on BIDS...ie..Business Intelligence Development Studio...
Actually..wat ever the reports we create using BIDS...to access them in our applications ...(as a web site in your case....), We need to deploy those on a report server...(it may be a local system or a remote server) and we can bind the same server URL to a report viewer control in order to access the concerned reports...:)..in our web page...
I hope..this should help you...:)
Thanks alot,
Niraj
Thanks for the reply Niraj.
This web site still has a lot of development left to do, but the customer is already using the sections that are ready. So far, have only had to do a few reports and they did work as local reports.
Then this assessment report required data from like 7 differrent queries for different sections. I have the report server up and running, and the new reports looks great.
Then the customer went to run one of the local reports and the report viewer resquested a login to the webserver. This has never happened before.
Trying to determine if I will now have to move all reports to the report server. One should be able to utilize both local reports built by the Visual Studios 2008 report designer and remote reports built in BIDS.
Trying to understand why the local reports now request to login to the report server. The ASP.net 20 report viewer control is set to local report with the report path set to a subfolder to the root of the website.
Makes no sense to me!
R.Barbre
November 24, 2008 at 6:29 am
There it is!!
I think...Report Viewer control should access the report server URL to access reports which are already placed on Report Server...Right!
So...for this..the processing mode for a report viewer control should be set to Remote and along with this...we need to pass the server URL too...I think..this can be done at coding end where we can set few conditions, on the basis of which it will identify whether user has demanded for a local report or a server report...
...I guess...this may help..:)
Niraj
November 24, 2008 at 6:42 am
Niraj (11/24/2008)
There it is!!I think...Report Viewer control should access the report server URL to access reports which are already placed on Report Server...Right!
So...for this..the processing mode for a report viewer control should be set to Remote and along with this...we need to pass the server URL too...I think..this can be done at coding end where we can set few conditions, on the basis of which it will identify whether user has demanded for a local report or a server report...
...I guess...this may help..:)
Niraj
Right for the first part. The one report has been deployed to the report server. When the user request this report, they are sent to the report server and the report is processed and viewed through the report viewer from the report server. I get the parameters in code and send via the URL to the report server, so that part of the viewer is turned off for the report.
Now the local reports use the report viewer within Visual Studios. The control is set to local mode and the report path is set to a report with the folder structure in the web site. This is sone either by the viewer properties, or by the C# code behind.
Yet the local report now requests a login to the server, this has never happened before the report server was set up and the one report deployed!
R.Barbre
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply