Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Example: Create a Drill-To Report Link for Ledger Account Reports

Example: Create a Drill-To Report Link for Ledger Account Reports

This example illustrates how to create a drill-to link from a ledger account summary report to a ledger account detail report.
You're the Chief Financial Officer of Global Modern Services, and you want to create a summary report of debit minus credit amounts for each ledger account type. You also want to create a detailed report of the actual ledger accounts and display the debits and credits for each account.
Using drill-to report links, you can link these reports so that clicking on a value from the summary report takes you to the detailed report.
Security: These domains in the System functional area:
  • Custom Report Creation
  • Custom Report Management
  1. Access the
    Create Custom Report
     task and enter:
    Option Description
    Report Name
    Ledger Account Details
    Report Type
    Matrix
    Data Source
    Journal Lines
  2. Click
    OK
    .
  3. On the
    Matrix
     tab in the
    Row Grouping
     grid, select:
    Group by Field
    Ledger Account Type
    Account Posting Rule
    Ledger Account
  4. In the
    Column Grouping (Optional)
     grid, select
    Year
     from the
    Group by Field
     prompt.
  5. Add 2 rows in the
    Define the Field(s) to Summarize
     grid, remove the
    Count
     summarization type, and enter:
    Summarization Type
    Summarization Field
    Label Override
    Format
    Sum
    Ledger/Budget Debit Amount
    Debit Amount
    #,##0
    Sum
    Ledger/Budget Credit Amount
    Credit Amount
    #,##0
  6. On the
    Filter
     tab in the
    Filter on Instances
     grid, add 2 rows and select:
    And/Or
    Field
    Operator
    Comparison Type
    Comparison Value
    And
    Ledger Account
    in the selection list
    Prompt the user for the value and ignore the filter condition if the value is blank
    Default Prompt
    And
    Ledger Account Type
    in the selection list
    Prompt the user for the value and ignore the filter condition if the value is blank
    Default Prompt
  7. On the
    Prompts
     tab, select the
    Populate Undefined Prompt Defaults
     check box.
  8. In the
    Prompt Defaults
     grid, add 2 rows and select:
    Field
    Prompt Qualifier
    Default Type
    Ledger Account Type
    Default Prompt
    No default value
    Ledger Account
    Default Prompt
    No default value
  9. On the
    Share
     tab, select
    Share with all authorized users
    .
  10. Click
    OK
    .
  11. Access the
    Create Custom Report
     task and enter:
    Option Description
    Report Name
    Ledger Account Summary
    Report Type
    Matrix
    Data Source
    Journal Lines
  12. Click
    OK
    .
  13. On the
    Matrix
     tab in the
    Row Grouping
     grid, select
    Ledger Account Type
     from the
    Group by Field
     prompt.
  14. In the
    Define the Field(s) to Summarize
     grid, remove the
    Count
     summarization type, and select:
    Summarization Type
    Summarization Field
    Format
    Options
    Sum
    Ledger/Budget Debit minus Credit
    #,##0
    Create Drill-To Report Link
  15. On the
    Create Drill-To Report Link
     task, enter:
    Option Description
    Drill-To Report Name
    Ledger Account Details
    Label
    Ledger Account Details
  16. In the grid, select:
    Prompt
    Value Type
    Field/Parameter
    Ledger Account Type
    Use value from axis dimension
    Ledger Account Type
    Company
    Use prompt value from source report
    Company
    Year
    Use prompt value from source report
    Year
  17. Click
    OK
    .
  18. Click
    OK
    .
You can run the
Ledger Account Detail
 report for the summarization value of each ledger account type in the
Ledger Account Summary
 report.