DSStudio Report/Output Column Formats
Let’s define the columns on our DSStudio Report/Output Column Format Spreadsheet.
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.
Samples of numeric formats
Samples of text formats
(954)123-4321 Phone Numbers
999-99-9999 Social Security
Samples of date formats
Friday, Jan 1, 2021
Friday, January 1, 2021
January 1, 2021
Samples of time formats
Samples of boolean formats