How can you programatically export from Reporting Services via C# using VS.NET 2003 + SQL Server

Hi,

I'm not sure if this is possible, i've been looking round various sites for the past couple of days and have only found information on how to export reports in Reporting Services 2005.

What i am wanting to do is create a front end in which the user can specify where the report is to be exported to and the click a button which will export the report to that location into a pdf format.

ThanksYOu can simply get the report as a byte[] which is the return type of the Render method and save this as a filestream to the designated path.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||Thanks for the reply. However, which object has the Render method?

I only have reporting services for visual studio 2003.|||

A simple one can be found here: http://support.microsoft.com/?kbid=875447

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

How can you programatically export from Reporting Services via C# using VS.NET 2003 + SQL Se

Hi,

I'm not sure if this is possible, i've been looking round various sites for the past couple of days and have only found information on how to export reports in Reporting Services 2005.

What i am wanting to do is create a front end in which the user can specify where the report is to be exported to and the click a button which will export the report to that location into a pdf format.

ThanksYOu can simply get the report as a byte[] which is the return type of the Render method and save this as a filestream to the designated path.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||Thanks for the reply. However, which object has the Render method?

I only have reporting services for visual studio 2003.|||

A simple one can be found here: http://support.microsoft.com/?kbid=875447

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

How can we RETAIN the Tooltip value shown on report into in Excel Sheet

Is there any way in which i can carry or retain the tooltip value which is shown on my report into Excel sheet ...

i mean when i export the report into Excel sheet, tooltip value is gone?? how can i retain the tooltip value when i export into excel ??

is it possible if so ...any hints? thanks a lot in advance

any thoughts on this...at least can anyone suggest me how to control the export feature of report?? i mean can i write custom rendering events etc?

i really appreciate...if some reply to this thread

How can we RETAIN the Tooltip value shown on report into in Excel

Is there any way in which i can carry or retain the tooltip value which is
shown on my report into Excel sheet ...
i mean when i export the report into Excel sheet, tooltip value is gone'
how can i retain the tooltip value when i export into excel '
thanks a lot in advanceOn May 9, 1:23 pm, Dia <D...@.discussions.microsoft.com> wrote:
> Is there any way in which i can carry or retain the tooltip value which is
> shown on my report into Excel sheet ...
> i mean when i export the report into Excel sheet, tooltip value is gone'
> how can i retain the tooltip value when i export into excel '
> thanks a lot in advance
As far as I know, there is not a way to do this. I believe the only
export format that supports tooltips is Web Archive. Sorry that I
could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

How can I tell which SP is in error when trying to Export?

I am trying to Export a database to another using the export wizard. It
states that it found an invalid column name on one of the stored procedures
but doesn't say WHICH strored procedure, which is problematic since there
are nearly a thousand of them.
Does anyone know how to tell which sp is in error?"Tom" <nfr@.nospam.com> wrote in message
news:uyu4zBFOEHA.204@.TK2MSFTNGP10.phx.gbl...
> I am trying to Export a database to another using the export wizard. It
> states that it found an invalid column name on one of the stored
procedures
> but doesn't say WHICH strored procedure, which is problematic since there
> are nearly a thousand of them.
> Does anyone know how to tell which sp is in error?
There must be Details button I think...
Else it is safe to generate script of all of your procedures (Select them in
EM - all tasks -> generate script) and run it on same database from Query
Analyzer - you will see what is the exact error and where.
Bojidar Alexandrov

How can I tell which SP is in error when trying to Export?

I am trying to Export a database to another using the export wizard. It
states that it found an invalid column name on one of the stored procedures
but doesn't say WHICH strored procedure, which is problematic since there
are nearly a thousand of them.
Does anyone know how to tell which sp is in error?"Tom" <nfr@.nospam.com> wrote in message
news:uyu4zBFOEHA.204@.TK2MSFTNGP10.phx.gbl...
> I am trying to Export a database to another using the export wizard. It
> states that it found an invalid column name on one of the stored
procedures
> but doesn't say WHICH strored procedure, which is problematic since there
> are nearly a thousand of them.
> Does anyone know how to tell which sp is in error?
There must be Details button I think...
Else it is safe to generate script of all of your procedures (Select them in
EM - all tasks -> generate script) and run it on same database from Query
Analyzer - you will see what is the exact error and where.
Bojidar Alexandrov

How can I tell which SP is in error when trying to Export?

I am trying to Export a database to another using the export wizard. It
states that it found an invalid column name on one of the stored procedures
but doesn't say WHICH strored procedure, which is problematic since there
are nearly a thousand of them.
Does anyone know how to tell which sp is in error?
"Tom" <nfr@.nospam.com> wrote in message
news:uyu4zBFOEHA.204@.TK2MSFTNGP10.phx.gbl...
> I am trying to Export a database to another using the export wizard. It
> states that it found an invalid column name on one of the stored
procedures
> but doesn't say WHICH strored procedure, which is problematic since there
> are nearly a thousand of them.
> Does anyone know how to tell which sp is in error?
There must be Details button I think...
Else it is safe to generate script of all of your procedures (Select them in
EM - all tasks -> generate script) and run it on same database from Query
Analyzer - you will see what is the exact error and where.
Bojidar Alexandrov