Report Output Handler Flow
  • Updated on 05 Mar 2019
  • 5 minutes to read
  • Print
  • Dark
    Light

Report Output Handler Flow

  • Print
  • Dark
    Light

This tutorial demonstrates how to create and use a Report Post Processing Flow . This Flow type is used as a Report Output Handler . With this Flow configured, users will get a new option of saving a Report onto an excel file. This Flow takes in Report Data and organizes this Report Data onto an ExcelFile. The Flow then outputs this custom Excel File . This kind of Flow may be used in a similar manner as a Report Output Template. In this example, create a simple Report . Then create a Report Post Processing Flow that will arrange Report data into an ExcelFile . Finally, use this Flow to save the Report as an Excel file.
Use theSet Values In Column Step to order Report data onto the***Excel Template*** using Excel steps in the Flow .

Create a Report Output Handler Flow

A Report Handler Flow is a flow behavior that can be set in the settings under Behavior Type or a Report Handler Flow can be set up by navigating from the designer Folders to System > Designers > Report Output > Handlers Folder and select Add Report Output Flow on the blue Folder Actions Pane.
2018-09-14_101857.jpg

Flow Example

Running Post Processing Flow On Report Output
The example below is a flow built using aReport Output Handler for the purpose of processing a report onto an Excel File.

Steps:

  • Create Data: Data> Create Data Step
  • Set Values In Column 1: Integration/ Excel and CSV>SetValuesInColumn
  • Set Values In Column 2: Integration/ Excel and CSV>SetValuesInColumn
  • Update File With Data: Integration/ Excel and CSV>UpdateFileWithData

2018-09-12_155026.jpg

Create Data Step

In the Create Data Step selectshow editor to open the Data Definitions editor.
2018-09-12_163125.jpg

Adda Data Definition and name itFile". Define its Type File Data. Under Inputs next to File select Constant and upload the file using either the Drag file here or Choose file option.
2018-09-10_164256.jpg

Set Value In Column (1)

  • Column: Defines the column that will populate the Excel file from the report.
  • fields Start With Equals Are Formulae: Tells excel whether it should treat strings that start with = as a formula or just a regular string
  • file type: selects the type of file that the report data will upload onto.
  • input: Can choose what data you will input. In this case, select the string that was created in the Create Data Step.
  • Row: Defines the row that will populate the excel file from the report.
  • Try to Parse Numbers: Declares whether or not a set of numbers should be interpreted as a string or a number.
  • Values: This is where you define the values coming from the report. Select the Report and choose the data on the Report needed.
  • Worksheet number: Defines the page number that the data needed starts on.

Next, select the Set Values In Column Step (1) in the Flow designer and edit the Input settings. Under Inputs and next to column select Constant and define the column with a number for the data to populate on the Excel File (1). Setfields Start With Equals Are Formulae toConstant . Set file Type to Constant and select the Type from the drop-down list. Next to, input chooseSelect Form Flow and choose the Data Definition created from the Create Data Step, (File).

2018-09-13_110559.jpg

Set Row to Constant and enter the row number that should be populated on the Excel File (1). Next to, try To Parse Numbers set to Constant and check the box. Set Values to Select From Flow andPick theReport Data and theField that will populate the Excel File.
2018-09-13_110646.jpg

Set Value To Column (2)

Next, add a second Set Values In Column Step in the Flow designer and edit the Input settings. Under Inputs and next to column select Constant and define the column with a number for the data to populate on the Excel File (2). Setfields Start With Equals Are Formulae toConstant . Set file Type to Constant and select the Type from the drop-down list. Next to, input chooseSelect Form Flow and choose theData Definition created from the Create Data Step, (File).
2018-09-12_153425.jpg

Set Row to Constant and enter the row number that should be populated on the Excel File (1). Next to, try To Parse Numbers set to Constant and check the box. Set Values to Select From Flow andPick theReport Data and theField that will populate the Excel File.
2018-09-12_153621.jpg

Update File With Data

Select the Update File with Data Step and edit the settings. UnderInputs and next tofile type choose Constant and select thefile type from the drop-down list. The file type selected for this example is Excel_xlsx.
2018-09-12_154313.jpg

End Step

Next, connectUpdate File With Data step to the End Step in the Flow . Select End Step and map the Output (FileData) to the Output .
2018-09-12_154649.jpg

The Excel file will serve as a Template for the Report data. This completes the Flow example, save and close Flow Designer.

excelFile.png

Run a Report onto an Excel File using the Report Output Handler Flow.
note: Before a report can be run on an Excel File the Flow must be  Output Handler Flow must first be created. If The Report and the Output Handler Flow have been created simply select the Output Handler Flow in the example as follows.

Select Run Report from the orange action panel located on the top of the Report dashboard. 
run-report.jpg

Select the Settings wheel on right and choose the printer icon.
2018-09-14_121631.jpg

Under Settings and underOutput Type chooseAccount Report Handler and select Proceed.
2018-09-14_122357.jpg

Download the Exported Report and open in the Excel Template.
2018-09-14_122735.jpg

Open up Excel and navigate toFile>Import and thenUpload the file to the Excel Template to see it populated with the Email Address and Account Id.
2018-09-14_132443.jpg

This completes the Report set up. Save and Exit to the designer Folder.

Was this article helpful?