Link External Data Connection with a Workflow that has a report
I have been successful in using a external data connection by running a report straight from the viewer. So, how does one feed this data connection into a workflow that uses a similar output report? Using the multi layer workflow that's available, I'm trying to get the same results, but am not successfull in trying to feed my data connection into the workflow.
Any suggestions would be appreciated.
Walter
-
On the Geocortex Workflow Designer, there are two product activities to generate a report: (1) 'Report' activity under 'Common Client' group (2) 'Template Report' under 'Common Server' group.
The first one is the client activity as you can see. Generally you can use this when you configured the LayerTemplateReport under any specific Layer where you may configure DataLink(s) and FeatureMap(s) which are available on the 'Report' activity as the datasource on the WF. It is great one to use if you don't have any other custom things to do on the data source for 'rpx' file, but you can't change the datasource (dataset) to massage any more.
The latter one offers more flexibility but you need to do more to generate the 'DataSet' by yourself as the DataSource for the report template (.rpx).
You can use 'SqlQuery' activity to get the database output as the datatable, and add it to your Dataset, and datatable converted from the FeatureSet from QueryTask to the dataset etc.
To make it short, as far as I understand correctly on your posting, you may use the first case (but not sure how you ran areport from the viewer, but that is my guess you configured LayerTemplateReport with the datalink, right?)
It either of above two does not fit on your questions, please post the current implementation and goal in deatil.
Munhwan
0 -
Munwhan,
Thank you very much for a superb response. It was much appreciated. I will look at the options you've mentioned and see if I can bring in my dataconnections from my external source.
I'll let you know how I do.
And thanks again......Walter
0 -
Basically we need to run summary totals on fields in the configured dataconnection on the selected data present in the tableview, through workflow. we can plainly see the data from the dataconnection in the selection table, so we know that is properly configured. or getselected workflow contains a geocortex featureset. is there a way to parse the geocortex features result to a datatable or a summary loop of some kind.
Any suggestions would be appreciated.
J
0 -
There are few conversion activities (under Conversion toolbox group) avaialble among FEatureSet, DataTable, etc on the workflow designer, such as FeatureSetToDataTable, DataTableToFeatures. To group the fields, you need to sort your datasource (dataTable) first, which you may get the help with SortFeatureSet activity. 1) create a dataset (ds = New DataSet) 2) Add a dataTable to ds using AddToDataSet under Collections 3) Use TempalteReport which requires rpx uri, Dataset, and return Report Data. To get the summary, you need to design .rpx file to do (refer http://help.cwebtechnologies.com/ssm/howto/creating_summary_totals.htm), which is to create the Report output. If you want to show on the viewer, yes I think you need to loop through DataRow to build a new data for the summary. 0
Please sign in to leave a comment.
Comments
4 comments