Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    5

    Unanswered: Totals from subreport in main report

    I have a report with five subreports. Each of the subreports has a calculated total. In the main report the totals of subreport 1, 2 and 5 are summed.
    If subreport 2 has no data, it is not shown in the report, which is what I want . However, consequently, there is no subreport total, so the sum in the mainreport gives an #error nz() does not work, because the subreport.total does not exist at all. Any idea how to solve this? I tried playing with hasdata, but lost track.

    Thank you in advance,

    Peter
    Last edited by PJThys; 05-18-04 at 17:23. Reason: correct spelling error

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Peter

    You could try this expression to evaluate whether to add 1, 2 and 5 totals or just 1 and 5 (effectively what it sounds like you've been playing with!):

    =IIf(Reports!rptMain!subReport2.Report.HasData="-1", expr to add 1 + 2 + 5 totals, expr to add 1 + 5 totals)

    Hope his helps
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    May 2004
    Posts
    5
    Thanks, you saved my day, Works like a charm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •