Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    40

    Question Unanswered: Refer to Subreport result in Main Report

    I have Subreport which lists Invoice Balances and Invoice Payments. At the end of this subreport is a simple sum which has [Balance]-[Paid] to return the ammout outstanding/in credit. This is called [credit].

    What I want to do is display the result of [credit] on the ride side of the main report with the invoice totals. How do I refer to a subreport like this? I've tried
    =[Reports].[SubReportName(which is Balance)].[Credit] and
    =Reports![Invoice]![credit].Report[credit] which I got off the MS Support Page but neither work.

    What am I missing?

  2. #2
    Join Date
    Dec 2007
    Posts
    40
    After much googleing I've found the solution. It's one of those problems that's so simple it's quite hard to find anything relevent as most other questions are way too advanced.

    Just for reference and for the benefit of anyone who's found this thread and has a similar problem check out http://allenbrowne.com/casu-18.html.

    Amused

Posting Permissions

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