| Groups | Blog | Home |
sql server reporting services : Report Viewer Question
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
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 [quoted text, click to view] "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. [quoted text, click to view] "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 [quoted text, click to view] "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 [quoted text, click to view] "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 >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |