Showing posts with label rdl. Show all posts
Showing posts with label rdl. Show all posts

Friday, March 23, 2012

running 2005 rdl on a RS 2000 server

We have written some RS 2005 reports on a development server which now needs
to have SQL Server 2005 re-installed due to 'Database Services' not
installing successfully with SP1. Some of the 2005 reports are currently in
use and I wanted to install them on a RS 2000 report manager on another
server during the downtime.
I am receiving the error 'report definition not valid' which relates to the
schema definition when I try to import these reports into Visual Studio 2003.
Changing 2005 to 2003 in the schema def does not work. Is it possible to
run a RS 2005 report in RS 2000 Report Manager? The report does not use any
of the new features available in RS 2005.No it is not possible natively. You might be able to hand edit the RDL (in
notepad) to make it work. I have heard that this might be possible.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bhorwatt" <bhorwatt@.discussions.microsoft.com> wrote in message
news:06261017-B5CD-497E-A468-ABED703B0D8A@.microsoft.com...
> We have written some RS 2005 reports on a development server which now
> needs
> to have SQL Server 2005 re-installed due to 'Database Services' not
> installing successfully with SP1. Some of the 2005 reports are currently
> in
> use and I wanted to install them on a RS 2000 report manager on another
> server during the downtime.
> I am receiving the error 'report definition not valid' which relates to
> the
> schema definition when I try to import these reports into Visual Studio
> 2003.
> Changing 2005 to 2003 in the schema def does not work. Is it possible to
> run a RS 2005 report in RS 2000 Report Manager? The report does not use
> any
> of the new features available in RS 2005.sql

Wednesday, March 21, 2012

Run SQL Server Report from .Net WIndows App...

Does a report have to be run from the Report Manager (IIS), or can rdl files
be executed from .Net code in a Windows Application?
I quess what I am asking is, with Crystal and VB 6, I can lauch a report
through a control embedded in the exe file.
Is there a control to place in a Windows Form that can view a report without
haing a IIS Report Manager?
--
Thanks,
ThomasLL, MCDBAI'm pretty sure SQL Reporting Services 2005 will have a WinForms and a
WebForms viewer.
"Thomas.LeBlanc@.NoSpam.Com" wrote:
> Does a report have to be run from the Report Manager (IIS), or can rdl files
> be executed from .Net code in a Windows Application?
> I quess what I am asking is, with Crystal and VB 6, I can lauch a report
> through a control embedded in the exe file.
> Is there a control to place in a Windows Form that can view a report without
> haing a IIS Report Manager?
> --
> Thanks,
> ThomasLL, MCDBAsql

Tuesday, March 20, 2012

Run Report via Command Line

Is it possible to run a .rdl report via command line? What would be
the syntax?
Thanks
BobOn Apr 10, 7:25 am, "Bob" <b...@.ebearings.com> wrote:
> Is it possible to run a .rdl report via command line? What would be
> the syntax?
> Thanks
> Bob
In SSRS 2000, it could be done via rs.exe at the command line;
however, in SSRS 2005 it will take a bit more work. This link might be
helpful:
http://msdn2.microsoft.com/ko-kr/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.aspx
Regards,
Enrique Martinez
Sr. Software Consultant