Setting Column Properties in the Report Designer

Last Updated: 05/03/2018 Introduced in Version: 2.0

Column widths, titles and other formatting options can be set in the Properties Panel of the Report Designer.  To adjust a column’s formatting options, select its header and modify settings in the Properties Panel.  To see these changes in action, click the Refreshing Preview button in the Report Designer or select the Run Report action in the portal.

Example

The goal of this example is to:

  1. Create a report and add columns to it.
  2. Set the width for two of the columns and preview them in the Report Designer.
  3. Run the report and view the columns with the set width.

To begin, go to the portal and navigate to a Designer Folder.  Click on the Create Report button and select Create Report.

 

 

In the resulting New Report pop-up window, give the new report a name and click Ok.

 

 

Define a data source for the report by selecting Folder Data Source for the Sources list from the Data Sources > Common category in the Toolbox Panel.

 


 

Next, setup the results of the report, those columns that will be measured.  From the Data Field field select the Add button and choose Entity Name, Folder Type Name, and Nesting Level as our columns.

 

 

Next, resize the Entity Name column to be 250 pixels wide.  In the Properties Panel, under the Settings section, select the Width field and type “250”.

 

 

To see the change, click the Refresh Preview button.

The Entity Name column will be 250 pixels wide.

Next, resize the Folder Type column to be 250 pixels wide.  In the Properties Panel, under Settings section, select the Width field and type “250”.

 

 

To see the changes, will click the Refresh Preview button.

The Folder Type column will be 250 pixels wide.

This completes the report.  Save it and close the Report Designer.

Back in the portal, select Folder Report and in its Action menu, select Run Report.

 

 

The report will open in a new window where the user can see the Entity Name and Folder Type folders are both 250 pixels wide.

 

Additional Resources