Example: Create Custom Report for Available Report Fields
This example illustrates how to build a custom report that lists report fields that are available to use in calculations.
At Alma Mater University, Julie Winston is responsible for creating and maintaining financial aid calculations. A custom report enables her to reference an up-to-date list of available report fields as she designs and builds the calculations. Julie collaborates frequently with Valerie Rodriguez, who is responsible for student financials calculations, and wants to her to have access to the report as well.
Security:
Custom Report Creation
domain in the System functional area.- Access theCreate Custom Reporttask.
- Enter or select these values:FieldValueReport NameFinancial Aid Report Fields for CalculationsReport TypeAdvancedOptimized for PerformanceClear this check box.Data SourceFields
- ClickOK.
- Add these rows to the grid on theColumnstab:Business ObjectFieldFieldFieldFieldBusiness ObjectFieldDescription
- On theFiltertab, add these rows to theFilter conditions for filtering on instancesgrid:And/Or(FieldOperatorComparison TypeComparison Value)AndCategoriesany in the selection listValue specified in this filterFinancial AidAndAuthorized Usageany in the selection listValue specified in this filterCalculation Engine (Payroll/Absence)
- On theSharetab, grant Valerie Rodriguez permissions to the report.
- SelectShare with specific authorized groups and users.
- In theAuthorized Usersprompt, selectValerie Rodriguez.If you're building this report on behalf of Julie, add her here too.
- ClickOK.
- ClickRun.
The
Financial Aid Report Fields for Calculations
report lists the report fields in the Financial Aid category that Julie can use in calculations for financial aid. Valerie also has access to this report and can use it as a reference for her own calculations as needed.