Specifying Formatting Options
The PeopleSoft Query Link portion of PS/nVision uses a standard Microsoft Excel template, QUERY.XLT, to format data retrieved from a query. QUERY.XLT contains some special styles that you can personalize. Use the Excel Format, Styles option and save your changes to QUERY.XLT.
Note:
The location of QUERY.XLT is specified on the nVision tab of the Configuration Manager in the Query Templates dialog box.
The following table lists the special PeopleSoft styles that you can apply to QUERY.XLT.
| Style Name | Data Type Formatted |
|---|---|
|
PSChar |
Character fields (such as names) |
|
PSDate |
Dates |
|
PSDec |
Numbers with decimal places, such as dollar amounts |
|
PSInt |
Integers (such as years) |
|
PSHeading |
Column headings |
|
PSSpacer |
Space between data columns |