Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a report that shows details from two subreports which are based on cross tab queries. Each of the sub-reports has totals calculated on the report. I want to add the two totals together.
    However in some cases, there will be no data for one or both of the cross tab queries and therefore the report. This means I get an #Error# in the total of the individual sub report and also in the total. Is there any way to treat the subreport with no data as zero and therefore get a total of the two.
    TIA
    Steve
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Reports have an "HAS DATA" property, which is true or false.

    So you should be able test that with an If statement, and either use total from the report, or 0 if the report does not have data.
    Regards
    John



  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='johnhutchison' post='792664' date='09-Sep-2009 11:35']Reports have an "HAS DATA" property, which is true or false.

    So you should be able test that with an If statement, and either use total from the report, or 0 if the report does not have data.[/quote]
    Sorry - senior moment.
    These are in a Form not a Report
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

Posting Permissions

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