DSStudio Report/Output Column Formats

Let’s define the columns on our DSStudio Report/Output Column Format Spreadsheet.

Description

This is just the column number for reference.  It is useful if we have questions about a pictural column.  We can quickly reference by number.

This would be the field name within the dataset or a custom name to describe the column or data element.

The contents of the column header.  Normally appears on the top of each page or grouping.  Examples would be: Customer ID, Employee Name, Address.

Formatting columns and data within your report is important for readability and design.  Looking at how values are formatted gives you instant recognition of what the value is.  But then sometimes $, cents, and other punctuation just creates noise and extra space on your output.

If you use the data to export to a different format like CVS, you need to know what format the importing system requires.  Date and numeric formats for important.

Boolean

Samples of boolean formats

Yes
no
True
False
0
1
Go
Stop