Help with saving a SQL Reporting Services report as pdf

[Martin_]

Hi, I need help saving reports as pdf. Right now, the user has to run the report and save it as pdf manually. Is there a way to do this dynamically? Thanks, Martin

[The Man from U N C L E]

They could subscribe to the report and have it emailed to them as a pdf.

If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) [My Articles]  [My Website]

[Martin_]

Thanks, but I have to be able to run the reports and save them. Martin

[The Man from U N C L E]

Subscriptions do have an option to output to a given directory. Of course Reporting Services may not be the correct tool for the job. What is the end goal? Presumably the end user does something, or clicks something that generates this pdf? If you are merely using reporting services to dump a grid, or Form to PDF there are many other ways of doing it. The Infragistics Grid, for example, has Export to PDF built in, as do others. There is also an open source PDF writer out there called SharpPDF[^]. I believe the learning curve is pretty steep though. If you are in a pure web environment I would have thought Reporting Services pretty much does the job.

If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) [My Articles]  [My Website]

[Martin_]

The end goal is to create a nice looking report and save it as pdf. I have to format the report. This is a VB.NET background application without a GUI. At the end of the day, it collects data and saves it as an easy to read pdf. Thanks, Martin