We have a 30 pages packet that we produce by state. We also get a 1 page pdf for each state from a different group that we end up having to manually add to the packages. Currently the package is produced where the recipient is the state, where the location is parameter we cycle through.
Is there a way to have reportworq look in the folder with the outside pdfs and find the one it needs.
Example: Nevada package looks through folder of 50 state pdfs for Nevada_Expenses and adds it into the package as page 14.
I’ve had a need for something similar before and there were two workarounds for dynamically grabbing a file that I used as I’m not sure the tool can do this yet but I’ll let those experts respond.
Creating the data sent manually to me in my datasource so I could re-create the PDF dynamically through the job.
Having the manual attachments loaded to SharePoint site and then adding in a dynamic link to the file via SharePoint vs direct attachment.
Great use case and thank you @karen.hewitt for sharing your workaround. I see an opportunity for an enhancement here. After loading up a report and configuring it (if needed) it would be ideal if you could go back and adjust the file path using a ReportWORQ Parameter. Since parameter’s exist at the beginning of the job, unlike other variables that are calculated afterwards, it seems we would have the information needed to load the file based on the parameter. A bonus would be to support global variables for broader changes.
One thing to work out is that some parameters only have a single value (e.g. the state) vs. other parameters with a list of values which are generally used to replicate sheets. In this case, I think we would add multiple instances of the report (another bonus). For example, if the New Jersey instance of the job had a City parameter with values: Middletown, Holmdel & Red Bank, and that City parameter was used in the path of a source file, then that job output would contain 3 copies of that source file. I also don’t see any reason why this wouldn’t work with Excel files too.
I’ve logged an enhancement and we’ll discuss with the team!