Report Delivery to Windows File Share

[xcaliber2222]

Hello all,

I have a single report which takes in a user_id parm and creates a report specific to a user. There are 500 of these users. Is it possible to set-up a subscription that will take in this parm and render format for each report to a pdf file? Once we have all the pdf files in a folder we can provide a link to the user to point to their specific file. I would like to avoid creating a separate report/rdl file for each user, the output of 500 pdfs is no problem, however. Hope this makes sense and if so, could please provide a brief walkthrough or example, or point me toward a resource?

Thanks,
Alejandro

 

[ousoonerjoe]

Could always loop through the 500 ids, pass one to the report, save as pdf, email the link, rinse and repeat.

"...and did we give up when the Germans bombed Pearl Harbor? NO!"
"Don't stop him. He's roll'n.

 

[xcaliber2222]

Thanks Joe.
Would I loop through these records in a table directly from custom code in the report? Can you tell me how/where you would loop through these records?
Thanks,
Alejandro

 

[xcaliber2222]

Joe,
Also, don't want to e-mail the reports, just have them saved to a file share.
Thanks,
Alejandro

 

[RiverGuy]

Nothing comes to mind besides setting up 500 supsrcriptions. One thing to consider would be to host your report in the ReportViewer control in .Net if you have Visual Studio. You should be able to automate the process of the specific exports from code.

 

[xlbo]

Have a look here:

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

for a tutorial on setting up data driven subscriptions...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[ousoonerjoe]

The more i think about this, the more it looks like it would be better to do as a Server Side report. Create a Login Page and from that page they enter the info needed and generate it themselves. If they want to keep a copy of it, they can "Save As" PDF.

i don't know what these reports are for, and unless they're needed in accounting or something then there is no need to generate it for them if they can do it themselves. Send out an automated email once a month as a reminder that the new data is posted and available to look at.

"...and did we give up when the Germans bombed Pearl Harbor? NO!"
"Don't stop him. He's roll'n.