The current default for Subject Area column displays is "suppress" when values in multiple rows repeat. Example:
Users requested to have this default changed to "repeat", since for each adhoc Report they have to go in for each column and set the column properties to repeat for easier use of the data in Excel. We have decided to go ahead and make that change globally.Your reports will continue to run, the only change is that the output will look different. Values will be filled in for all rows.
If you want to get back to have values suppressed on your existing reports you need to do the following.
Go to Criteria, the column you want to change back to suppress (in this example Appropriation Cd) and select the Column properties.
Go to the Column Format Tab, Change the Value Suppression back to Suppress.
Column Properties for Appropriation Cd set to suppress, click OK, and save your report.
The Appropriation Cd values are now suppressed again for this particular report.
Our approach is to start off with the Subject Areas that have no delivered reports. FMS - AP- Voucher
FMS - AP- Voucher Header
FMS - AP- Voucher Line
FMS - GL - Ledger Balances
FMS - GL - Commitment Control Transaction Log
FMS - GL - Commitment Control Encumbrance
FMS - GL - Commitment Control Detailed Ledger
FMS - GL - Commitment Control Activity Log
FMS - GL - Journal Entries
FMS - GL - Aggregated Balance
HCM- Payroll-Roster Staffing
Then move on to Subject Areas with delivered reports.FMS - ALL- Expenditures
FMS - AP- Account Entries
FMS - AP- Voucher Distribution Line
FMS - GL - Commitment Control Journal
FMS - GL - Commitment Control Budget Balances
FMS - GL - Commitment Control Appropriations
FMS - GL - Aggregated Balance
HCM - Payroll-Labor Distribution
HCM - Payroll-Salary Projections
We plan to have the change completed by April 14.
If you have any questions, please contact the SWIFT Help Desk by phone at 651-201-8100, option 2.