accessing report programmatically

I need to run a report, output it in a CSV format, and store it in a
specified directory. I am able to do it using VS.net report designer.
How can I programmatically specify the output format and the
destination directory?
I'm new to RS, thanks for you help.Yes you can. There is a book by WROX called SQL Server Reporting Services.
It has a chapter on programmatic rendering. The book is a must have for
those learning SQL Server Report Services. It's very straight forward and
easy to implement.
David
"Mark" <maratg3@.hotmail.com> wrote in message
news:ffcd6d4.0410121336.5c27434e@.posting.google.com...
>I need to run a report, output it in a CSV format, and store it in a
> specified directory. I am able to do it using VS.net report designer.
> How can I programmatically specify the output format and the
> destination directory?
> I'm new to RS, thanks for you help.

Accessing Properties of a ScriptTask

I have a ScriptTask, in the designer I've given it a name. Is there a way at runtime to pick up that name from within the code in the ScriptTask?

The TaskName system variable.
|||

Knowing the right term is everything! Thanks a million. For anyone else reading this, what I did was add TaskName to the read-only variables of the script task. I can then access the variable in the script with DTS.Variables("TaskName").Value.ToString. If you have a user variable called TaskName you'll have to use System::TaskName.

Thanks again Jay, just what I was looking for.

LarryC

Accessing Oracle data on RS2005 x64

I am developing reports in RS 2005 accessing Oracle data. It works fine
as long as I preview my reports in my local Report Designer. But after
have deployed my reports to my Windows 2003 EE x64 Report Server, I
cannot view my reports. I get the error message "Cannot create a
connection to data source ...".
I haven't had any problems before on 32-bit servers.
What Oracle client should I install on the x64 server ? I have tried
both the 32 and 64 bit version Oracle 10g Runtime Client. Or is there
some other trick to get this working ?
/RobertDo you really need the Oracle client? My impression was that you would
just need to setup an ODBC connection to the oracle DB on the server
and RS would use that to connect'
Hope this helps!
--
Ben Sullins
http://bensullins.com