DSStudio Report/Output Column Formats
![Help People Help People](https://dscorp.com/wp-content/uploads/2021/07/HelpPeople.png)
Let’s define the columns on our DSStudio Report/Output Column Format Spreadsheet.
Column
Description
Field #
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.
Field Name
This would be the field name within the dataset or a custom name to describe the column or data element.
Column Header
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.
Numerics
Text
Dates/Time
Boolean
Samples of numeric formats
125.65
$125.65
$125
$1,125.65
1,125.65
65.0152
%25.05
25%
Samples of text formats
(954)123-4321 Phone Numbers
954-123-4321
954.125.4321
999-99-9999 Social Security
999999999
Samples of date formats
1/1/2021
1/1/21
01/01/2021
2021-01-01
Friday, Jan 1, 2021
Friday, January 1, 2021
January 1, 2021
Jan-1-2021
Samples of time formats
6:30:00 AM
6:30 am
15:00
Samples of boolean formats
Yes
no
True
False
0
1
Go
Stop