如何用SSRS按日期循环生成每行对应PDF报表？

Absolutely—SSRS can handle this requirement perfectly, and there are a few straightforward ways to implement it. Here's how to approach it:

SSRS Native Approach: Data-Driven Subscriptions #

This is the most direct method within SSRS:

1. Build a Parameterized Single-Row Report
   Create a report that displays exactly one invoice's data (like your example rows 1111-example1-14/04/2018). Add a parameter (e.g., @InvoiceID) that filters the dataset to return only the matching row. Design the report layout to match what you want each individual PDF to look like.

2. Set Up a Data-Driven Subscription
   This feature lets you generate multiple reports from a dataset of rows:

   • First, create a dataset that returns all the rows you need PDFs for (you can filter this dataset to target a specific date like 14/04/2018 if needed). Include columns like INVOICE, COMMENT, DATE, and the unique identifier (e.g., InvoiceID) to pass to the report parameter.
   • Configure the subscription to use this dataset as its data source. For each row in the dataset:
     • Pass the InvoiceID parameter to your single-row report.
     • Set the output format to PDF.
     • Define the filename using the row's fields—just make sure to replace slashes in the date with hyphens (e.g., [INVOICE]-[COMMENT]-[REPLACE(DATE, '/', '-')].pdf) to avoid filename errors (most operating systems block slashes in filenames).
   • Choose where to save the PDFs (file share, SharePoint, etc.).

3. Run or Schedule the Subscription
   You can run it on demand for a specific date, or set up a schedule to generate PDFs automatically for new dates as they come in.

Alternative Methods (If SSRS Subscriptions Aren't Ideal) #

If you need more flexibility, these options work well too:

• Power Automate (Microsoft Flow)
  Pull your invoice data from your source (SQL, Excel, etc.), loop through each row, and use the "Render SSRS Report" action to generate a PDF for each entry. You can then save the PDFs to a desired location and format the filename using dynamic content from the row data.

• Custom Script/Application
  Use the SSRS Report Server API (SOAP or REST) to programmatically render reports. Write a C#/VB.NET console app or PowerShell script that queries your invoice data, then for each row, calls the API's render method with the appropriate parameters to generate the PDF and save it with your desired filename.

内容的提问来源于stack exchange，提问作者Piston