Report Viewer Web Part - Error - Help!

I am trying to integrate reports that I have built with VS 2005 and deployed to my report server locally.

The path to the report is

http://SERVERNAME/Reports/Pages/Report.aspx?ItemPath=%2fBilling+System+Reports%2fBasic+Financial+Reports%2fBasic+Financial+Statistics+-+TimeKeeper+YTD

When I put that into the "Report" parameter the web part display an error:

The report server has encountered a configuration error. See the report server log files for more information

And when I click on the ellipses, I get a pop up with the same error.

I installed SQL2005 SP2 and the RS Add on for MS sharepoint CTP

Any help would be great!

Thanks,

Erik

Assuming your report server is configured in SharePoint integrated mode (which I'm not sure it is). You don't use the report server path for the web part, you use the path to the report in SharePoint. You can get this path from the document library where the report is stored.

|||

What if I just want the web part to act like an iframe into the reporting services web front end, like the web parts for 2000 worked? Are these web parts not designed to work this way? If not, are there any 2005 web parts for viewing reports on the SSRS front end?

Thanks!

sql

Report Viewer Question

I am using rs on a SQL 2000 DB and have an application built using VWDE 2005
to display reports. I installed the ReportViewer control and set the
appropriate URL and report path. When I open the page, I first get a popup
to enter the password (is there a way to avoid this?) and then I get what
looks like a report manager window on the screen. I have to navigate to my
reports, select the one I want and then click on the "Full Screen" icon to
see the report.
How can I get a page to simply present the report when opened?
WayneIs the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going to
use the new controls to display reports you need to have RS 2005 installed
(which can use a SQL Server 2000 DB, that is what I am doing).
If you want it hardcode during design then using the for Report Path (click
on the upper right of the control to fill in the report tasks) put in
something like this: /MyFolder/MyReport not sure if case sensitive but it
could be. For your server this is what I have: http://Myserver/ReportServer
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>I am using rs on a SQL 2000 DB and have an application built using VWDE
>2005 to display reports. I installed the ReportViewer control and set the
>appropriate URL and report path. When I open the page, I first get a popup
>to enter the password (is there a way to avoid this?) and then I get what
>looks like a report manager window on the screen. I have to navigate to my
>reports, select the one I want and then click on the "Full Screen" icon to
>see the report.
> How can I get a page to simply present the report when opened?
> Wayne
>|||The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I don't
own the server.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going to
> use the new controls to display reports you need to have RS 2005 installed
> (which can use a SQL Server 2000 DB, that is what I am doing).
> If you want it hardcode during design then using the for Report Path
> (click on the upper right of the control to fill in the report tasks) put
> in something like this: /MyFolder/MyReport not sure if case sensitive
> but it could be. For your server this is what I have:
> http://Myserver/ReportServer
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set the
>>appropriate URL and report path. When I open the page, I first get a popup
>>to enter the password (is there a way to avoid this?) and then I get what
>>looks like a report manager window on the screen. I have to navigate to my
>>reports, select the one I want and then click on the "Full Screen" icon to
>>see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>|||I am pretty sure that the server needs to be RS2005. Looking at the info on
the controls it specifies RS 2005 for the server report. If you service
upgrades to RS 2005, they can continue to host RS 2000 reports. RS 2005 is
supposed to be backward compatible.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
news:OGU9aOd%23FHA.2300@.TK2MSFTNGP10.phx.gbl...
> The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I don't
> own the server.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
>> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going
>> to use the new controls to display reports you need to have RS 2005
>> installed (which can use a SQL Server 2000 DB, that is what I am doing).
>> If you want it hardcode during design then using the for Report Path
>> (click on the upper right of the control to fill in the report tasks) put
>> in something like this: /MyFolder/MyReport not sure if case sensitive
>> but it could be. For your server this is what I have:
>> http://Myserver/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
>> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set the
>>appropriate URL and report path. When I open the page, I first get a
>>popup to enter the password (is there a way to avoid this?) and then I
>>get what looks like a report manager window on the screen. I have to
>>navigate to my reports, select the one I want and then click on the "Full
>>Screen" icon to see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>>
>|||Thanks for the information - I'll check with my service provider.
Wayne
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23GcxKud%23FHA.160@.TK2MSFTNGP12.phx.gbl...
>I am pretty sure that the server needs to be RS2005. Looking at the info on
>the controls it specifies RS 2005 for the server report. If you service
>upgrades to RS 2005, they can continue to host RS 2000 reports. RS 2005 is
>supposed to be backward compatible.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
> news:OGU9aOd%23FHA.2300@.TK2MSFTNGP10.phx.gbl...
>> The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I
>> don't own the server.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
>> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going
>> to use the new controls to display reports you need to have RS 2005
>> installed (which can use a SQL Server 2000 DB, that is what I am doing).
>> If you want it hardcode during design then using the for Report Path
>> (click on the upper right of the control to fill in the report tasks)
>> put in something like this: /MyFolder/MyReport not sure if case
>> sensitive but it could be. For your server this is what I have:
>> http://Myserver/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
>> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set
>>the appropriate URL and report path. When I open the page, I first get a
>>popup to enter the password (is there a way to avoid this?) and then I
>>get what looks like a report manager window on the screen. I have to
>>navigate to my reports, select the one I want and then click on the
>>"Full Screen" icon to see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>>
>>
>

Report Viewer

Using the built in report viewer for the first time. Unfortunately I do not have SQL 2005 on the back end (and don't know if that would make a difference). I can get a basic report to run just fine. However, I am trying to hide certain columns depending on the criteria. While I can make a paricular column invisible the space it occupies is still shown on the display screen. So let's say I hide the first column, when the report is displayed I have a big gap between the left margin and the first displayed column. Any suggestions on how to either remove that gap or truely make the column invisible?Set the visibility of the column to false and set it as a toggle item dependent on some other textbox...