Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    69

    Arrow Unanswered: Compare values in Subreports

    I have a main report with some subreports.

    Let's say on the main report i calculate some totals.

    On the subreports i do the same calculation but on another way as a dubble check. (result should be same)

    Now we have to check manually both results if they match but i see mostly we forgot to do it or do'n do it properly.

    If i can compare the values from different report i can easily make an if (difference not 0 then ...." Values don't match.......

    But the problem is that the values apparently are private and not public so the variables of one report can not be used in another subreport.

    Anybody an idea for the esaiest sollution?

    Many Thanks
    West

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Anyway that you can do the comparison in a query or queries? Without knowing anything about the data and your reports, I personally would do the comparisons in a query. Then add the results of the query as another subreport that shows whether or not the comparison worked. You can even evaluate the results in the subreport to highlight or beep when the results don't match.

  3. #3
    Join Date
    Sep 2003
    Posts
    69
    Thank you for your reply!

    I guess i will have to do it that way. My report already contains 5 subreports and it's getting really slow.

    I thaugt there should be a possiblity to use the values in other subreports beacuse when you add a subrepport the wizzard asks which field you want to join

Posting Permissions

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