Skip to main content

how to get Workflow variable values into Report controls

Permanently deleted user

Is it me or are the Report Designer docs and examples a bit sparse?

I have a Workflow that produces values that are in VB variables in the workflow. The report is working fine, now I want to display its results on a Report.

I have a Report with Label controls. I want to display my workflow's variable values in those controls.

How do I plug a Report into a Workflow? Feel free to point me at docs if I should have RTFM.

Thanks!

0

Comments

4 comments

Date Votes
  • Permanently deleted user

    Upon reflection, the approach I am taking is this:

    1. populate my various variables with their values using the Assign activity
    2. create a Dictionary variable with an Assign activity
    3. add each of my variable values to the dictionary, each with an arbitrary human-meaningful key acting like a field name using the AddToDictionary activity
    4. use the DictionaryToDataTable activity to transform that dictionary into a DataTable with one row, with field names being the keys, and field values being the dictionary values
    5. add my various such DataTables to a DataSet, and provide that to the Report.
    0
  • Gord Coupland

    I'm having the same problem. Can anyone from Latitude chime in on this?

    0
  • Bernard Macnab

    Hello Mark and GCoupland,

    In Report Designer, add a label and look at the properties displayed in the properties window. There is a property called DataField under the Data subsection. Set this to the appropriate key from your dictionary and it should propegate through.

    When I am doing this from workflow, my dictionary is of the form Dictionary<string, object>. I am able to add byte arrays (for images) and strings to the dictionary and their values come through in the report.

    Let me know if this works for you!

    -Michael

    0
  • Permanently deleted user

    Hi Mark,

    The approach you are taking is the correct one. We do have an example workflow: (https://support.geocortex.com/essentialsGSCCodeGallery?sub-nav=codegall&main-nav=essentials&criteria=BESTANSWERS&id=kA4600000004EXN) Generate a multi-layer report that shows a similar implementation of this approach - bundling data into data tables.

     

    regards,

     

    Edmond

     

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post