![]() ![]() ![]() There are ways to run data-driven subscritptions without the Enterprise Edition using SSIS but the do take a bit of work. Learn more about organizing pages in a PDF file and combining files, including merging Microsoft Word, Excel, and PowerPoint files. Then, select a filename and location for the new file. You could even have that report only e-mailed to that user. When the PDF of extracted pages opens in a new tab, choose File > Save or File > Save As. When the data-driven query runs, it will create a record for each UserID which in turn will fire a report for each UserID using it as the parameter to limit the report to just that userID. UserID, 'ReportName for ' + UserName + ' on ' + GetDate() as ReportName Another field could have your ReportName that is derived from your data - ex. In your data-driven query (NOT the report but a different query used to fire the subscription), you would have a field for your grouping - your UserID in our example. You would have a parameter for the grouping (your page-break) - for example UserID. You would be able to do all of what you want in SSRS - if you have the Enterprise edition that has Data-Driven Subscriptions. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |