Reports

Show profit and loss account pages in Company and Group Five Year Summary reports

If the profit and loss account pages don't show the
Company Five Year Summary
 or
Group Five Year Summary
 reports, you can take the following steps to reset the display conditions.
  1. Run either the
    Company Five Year Summary
     or
    Group Five Year Summary
     report.
  2. Select the
    Report Structure
     tab.
  3. Expand the folders to view the
    Profit and Loss
     for the
    Company Five Year Summary
     or
    Group Five Year Summary
    .
  4. Right-click
    Profit and Loss – by function
     and select
    Properties
     from the context menu.
  5. Select the ellipsis button next to
    Display Condition
    .
  6. In the
    Edit Expression
     window, highlight and delete the option expression text.
  7. Insert the following replacement text for the option expression:
    reporting.queries.client.lookupaccountingperioddata("ClientSummaryTab|ReportOptions|ReportSettings|Presentation|IncomeStatementFormat|Current Period")[0].Value='Format 1 (Function)'
  8. Check that either
    True
     or
    False
     appears in the window.
  9. Select
    OK
    , then
    OK
     again.
  10. In the
    Report Structure
    , select the
    Profit and loss – by nature
     template.
  11. Right-click this template, then select
    Properties
     from the context menu.
  12. In the
    Element Properties
    , select the ellipsis button next to
    Display Condition
    .
  13. Highlight the option expression and delete the text.
  14. Insert the following text for the option expression:
    reporting.queries.client.lookupaccountingperioddata("ClientSummaryTab|ReportOptions|ReportSettings|Presentation|IncomeStatementFormat|Current Period")[0].Value!='Format 1 (Function)'
  15. Check that it either
    True
     or
    False
     appears in the window.
  16. Select
    OK
    , then
    OK
    .
  17. Run the report.
    note
    The profit and loss account pages should now be shown.
  18. If the profit and loss account pages are still not shown, select the
    Summary
     tab.
  19. On the
    Presentation
     tab, select either
    Format 1 (Function)
     or
    Format 2 (Nature)
    .
  20. Select
    OK
     to update the report.

This article applies to:

  • Product: Digita Accounts Production Advanced
  • Subject: Reports