DrillDown and Summary Ledger

When using DrillDown from a report based on a summary ledger, you can either translate summary ledger criteria into the corresponding detail ledger or drill down within the summary ledger.

To drill down within the summary ledger using the web, define the name NvsTranslateLedger in the DrillDown layout. PS/nVision reads this defined name at runtime.

  • If the value is Y, summary ledger criteria is translated into the corresponding detail ledger.

  • If the value is N, DrillDown within summary ledger is selected.

  • If NvsTranslateLedger is not defined, summary ledger criteria is translated into the corresponding detail ledger.

To define the name NvsTranslateLedger in the DrillDown layout:

  1. Use the Excel Insert, Name, Define command to define the name NvsTranslateLedger.

  2. Define the name as a string with either Y or N for the value.

Note:

If you are using the Windows client, PS/nVision continues to ask whether to drill within the summary ledger or drill to the corresponding detail ledger.