Form Value into Report
Is there a method for getting a value from a client form into a report activity? I would like a user to provide a string value for a zoning variance document name that will appear as a header on every page of a report.
Thanks
-
Hi Bill,
I recently had to do this for a report as well with the input of dates. I used a display form tool to add two date pickers to. From there I used an SQLQuery Tool to get the dates into SQL. You need to use the InvokeMethod Tool to convert the data table into a dataset and then pass this variable onto the Template Report tool. The output will be in byte format so you need to save it as a temp file and then add a hyperlink in order to view the report.
If your string value is simply just for display on each page and not going to be used as a spatial restraint for the output, you could likely skip most of the above steps and just reference the String input as a parameter in the rpx and skip the workflow section altogether.
This might be a bit over the top for what you're wanting to accomplish. I'm sure there is a simpler solution, this is just what worked for me.
Good luck.
0 -
William - Did you ever figure this out? I am looking to do the same thing. I have a workflow that collects input from the user in a form and passes selected features to a report. I would like to include the information from the form in the report. Any suggestions?
Thanks!0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
2 kommentarer