Generating PDF SSRS reports

Question

Hi,

I'm looking to generate an invoice report for each customer with it containing a list of billable items. I would like SSRS to some how generate a separate report for each customer as a PDF document (1 PDF per customer) and store it on a network folder.

Could you recommend a strategy on how I can design this in SSRS 2008. I would like to put the customers address details on the top of their report, a standard header and then have a table of billable items with a total etc.

How can I get SSRS to then run this for each customer so that it generates separate PDF documents and stores it to a network drive? Could I get it to store the pdf document by the customer number and name?

Thanks in advance.

Mason

Answer 1

Some ideas

http://dimantdatabasesolutions.blogspot.co.il/2009/02/how-to-render-report-to-pdfexcel-format.html

>>>How can I get SSRS to then run this for each customer so that it generates separate PDF documents and stores it to a network drive? Could I get it >>>to store the pdf document by the customer number and name?

Read about subscriptions in SSRS

---

Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

Blog : MS SQL Development and Optimization

Blog : Large scale of database and cleansing

Answer 2

Hi,

You can add User!UserID to your where clause like this:

where User_Name=@User_Name

and in Parameters tab in your Dataset Properties assign User!UserID to @User_Name

For user address and phone number you can add them to your where clause and then click Export and select PDF to export your report.

Please share the results.

Cheers

---

Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

Answer 3

Hi,

If you are on Enterprise Edition of 2008, you can use the data driven subscription to meet your requirement.

First step is to create a report which accepts a input parameter as customer id and create a report based on it. This is a simple task.

Now, you need to step a data driven subscription, as described below

http://beyondrelational.com/modules/2/blogs/101/posts/13460/ssrs-60-steps-to-implement-a-data-driven-subscription.aspx

Just in step-2 in above post, select "Windows File Share" in place of e-mail and provide UNC folder location which has appropriate rights for SSRS service account to create reports into it. In step-7, provide the schedule information.  No need to perform last step which involves SSIS.

For information on data driven subscription, have a look at this link 

http://msdn.microsoft.com/en-us/library/ms159150.aspx

Please note that data driven subscription is only available in Enterprise Edition of SQL server. If you do not have enterprise edition, you can create a program to export report to pdf, which calls a report for each customerid. Then you can schedule it using windows scheduler.

Kindly revert for any more information.

---

- Chintak (My Blog)