June 2, 2018 at 2:23 pm
Hello,
I have SSRS that contain Customers reminder lettres. I want to generate a pdf file for each Customer. I have tested page break but it dosen't work.
There is any way to do that ?
Thanks
June 2, 2018 at 6:07 pm
No, you'll need to generate multiple reports and export each separately. Exporting a single report does not create multiple files, it creates a single file. A page break inserts a page break (surprise), it doesn't split a document up. Just like when you insert a page break in Word, it doesn't create an entirely new document.
Edit: To clarify, I mean you need to run the report multiple times, with different parameters, not create a report for each Customer.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 2, 2018 at 6:41 pm
Thank you,
I think that the easy way is creating an SSIS package, add a task script in loop container (Like this dump) .
Dim url, destination As String
destination = Dts.Variables("Folder_Destination").Value.ToString + "\" + "Report_" + Dts.Variables("ReportParameter").Value.ToString + "_" + Format(Now, "yyyyMMdd") + ".pdf"
url = "http://localhost:8080/ReportServer?/MyReports/SSIS_Execute_SSRS_Report&rs:Command=Render&Productkey=" + Dts.Variables("ReportParameter").Value.ToString + "&rs:Format=PDF"
SaveFile(url, destination)
Dts.TaskResult = ScriptResults.Success
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply