DSStudio Report/Output Column Formats

Help People

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

 

 

 

Sage 50 and Peachtree Accounting Data Services

Data Recovery

Sage 50 US and Peachtree Accounting Data File Repair Service.

 Fiscal Period Change

Change the fiscal period time for a Sage 50 or Peachtree Accounting Company.

Data Transition

Many data-related services, which include: Sage 50 Product Downgrade, Quote Removal Service, Failed Fiscal Year Close Fix, and bulk change inventory item costing.

Purge Service

Data Purging Service for Sage 50 and Peachtree Accounting.  Reduce file size increase program speed.

Sage 50 Shell Company

Rebuild your Sage 50 / Peachtree Company in half the time.

Sage 50 Quote Stripping

Unable to import transactions into a new company.  The quote ” maybe getting in your way.