Automate exporting reports to PDF

I have read these two sites:
http://blogs.msdn.com/bryanke/articles/71491.aspx
http://scruffylookingcatherder.com/archive/2007/12/07/printing-reporting-services-2005-reports.aspx
But I'm new to Reporting Services and these methods aren't well documented
(that I can find). I have a report that has four parameters -- the second
parameter is queried off the value of the first, and could potentially have
up to five unique values for each unique first value. I need to generate a
report for each unique device listed in the second parameter, spit it out to
PDF for us to review and email to the clients.
Is there a command that can be used to do this? Or do I need to do a SQL
query or two myself to pull those values, and using a foreach statement
generate a report for each?
Any suggestions would be fantastic.
--Nathan Loding
Systems Associate, Special Projects
WESCO NetI doubt that RS has the capabilities you're looking for as that kind of
round-tripping would be frought with really complicated issues (mainly
maintaining state management). I did a cursory look at the client proxy
objects and nothing lept out at me that seems like it'd do what you're
looking for. I can't claim this to be an authoritative answer, but
personally, I'm betting you'll have to redo the queries client-side if you're
going to mimic the Report Manager functionality.
Jacob
"Nathan Loding" wrote:
> I have read these two sites:
> http://blogs.msdn.com/bryanke/articles/71491.aspx
> http://scruffylookingcatherder.com/archive/2007/12/07/printing-reporting-services-2005-reports.aspx
> But I'm new to Reporting Services and these methods aren't well documented
> (that I can find). I have a report that has four parameters -- the second
> parameter is queried off the value of the first, and could potentially have
> up to five unique values for each unique first value. I need to generate a
> report for each unique device listed in the second parameter, spit it out to
> PDF for us to review and email to the clients.
> Is there a command that can be used to do this? Or do I need to do a SQL
> query or two myself to pull those values, and using a foreach statement
> generate a report for each?
> Any suggestions would be fantastic.
> --Nathan Loding
> Systems Associate, Special Projects
> WESCO Net

Autoincrementing file share

Hi all,
I'm really new at reporting services. I'm hoping someone can help.
I have a subscription that runs daily. The MSDN tells me
"AutoIncrement, the report server appends a timestamp or number to the file
name to distinguish it from existing files of the same name".
Currently the number is being appended to the file name daily, however I
would like the timestamp appended. Any ideas how to achieve this?
Thanks
DebbieSorry about the duplicate posts. I couldn't find the original one I posted.
Now that I have found it, I can't delete this one. >_<
Debbie
"Debbie" wrote:
> Hi all,
> I'm really new at reporting services. I'm hoping someone can help.
> I have a subscription that runs daily. The MSDN tells me
> "AutoIncrement, the report server appends a timestamp or number to the file
> name to distinguish it from existing files of the same name".
> Currently the number is being appended to the file name daily, however I
> would like the timestamp appended. Any ideas how to achieve this?
> Thanks
> Debbie
>