Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts
    rptMain is a listing of club Members

    rptSub is a detail level sub report for each member depicting seminar paid date

    The field txtPaidOn is in rptSub and reflects a payment has been made when not null

    The txtPaidOn data name is PaidDate

    I'm trying to add a "Count" in the rptMain footer equivalent to the number of rptSub's "Paid dates"

    I've looked thru all of my own stuff, but haven't found anything that tried this and I've "searched" the forum without success which is probably because I haven't worded the search correctly.

    As always, would appreciate any help with this
    Cheers,
    Andy

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    There are several convoluted ways of doing that - most of which rely on putting a count in a hidden control in the sub-report footer that does the count and then updating the value on the main report footer. But is it necessary to have a subreport for what you are doing? It sounds from your description that you might be able to do a detail record in the body of the report and put the seminar description in either the report header or in a "group by" header, and put the total in the report footer, or the "group by" footer. That a fairly common way of doing this kind of report and avoids the problem of working with subreports.
    Wendell

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='WendellB' post='770142' date='11-Apr-2009 17:19']There are several convoluted ways of doing that - most of which rely on putting a count in a hidden control in the sub-report footer that does the count and then updating the value on the main report footer. But is it necessary to have a subreport for what you are doing? It sounds from your description that you might be able to do a detail record in the body of the report and put the seminar description in either the report header or in a "group by" header, and put the total in the report footer, or the "group by" footer. That a fairly common way of doing this kind of report and avoids the problem of working with subreports.[/quote]

    Hi Wendell,

    Thanks for responding. Unfortunately in this case, I have to do it the hard way. I would have normally embedded the seminar data in the individual's record. This would work if they attended only one seminar. In this case any one member can attend any number of seminars and the data for these seminars is tracked on an ongoing basis. So it would necessitate having multiple fields within the one record and that just wouldn't be appropriate in this case.

    What I have is a sub table which is related to the individual and can therefore track an infinite number of seminar attendances. This whole thing, I agree, is like sitting on a cactus.

    I'd be interested in seeing/hearing an example that you alluded to with hidden control scenario.

    Again, thanks kindly for your suggestions,
    Cheers,
    Andy

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    [quote name='AGMCon' post='770157' date='12-Apr-2009 14:47']Hi Wendell,

    Thanks for responding. Unfortunately in this case, I have to do it the hard way. I would have normally embedded the seminar data in the individual's record. This would work if they attended only one seminar. In this case any one member can attend any number of seminars and the data for these seminars is tracked on an ongoing basis. So it would necessitate having multiple fields within the one record and that just wouldn't be appropriate in this case.

    What I have is a sub table which is related to the individual and can therefore track an infinite number of seminar attendances. This whole thing, I agree, is like sitting on a cactus.

    I'd be interested in seeing/hearing an example that you alluded to with hidden control scenario.

    Again, thanks kindly for your suggestions,[/quote]
    Why go with a sub report scenario, this is what wendell suggested as well.
    You can do this via a grouping on change of individual, hence no need for sub reports. You can put your totals in the group footer for the individual.

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    [quote name='AGMCon' post='770157' date='11-Apr-2009 20:47']Hi Wendell,

    Thanks for responding. Unfortunately in this case, I have to do it the hard way. I would have normally embedded the seminar data in the individual's record. This would work if they attended only one seminar. In this case any one member can attend any number of seminars and the data for these seminars is tracked on an ongoing basis. So it would necessitate having multiple fields within the one record and that just wouldn't be appropriate in this case.

    What I have is a sub table which is related to the individual and can therefore track an infinite number of seminar attendances. This whole thing, I agree, is like sitting on a cactus.

    I'd be interested in seeing/hearing an example that you alluded to with hidden control scenario.

    Again, thanks kindly for your suggestions,[/quote]
    Pat has described the approach correctly. Put the data about the individual in the Group Header, the seminar data in the Detail section, and the totals in the Group Footer. Your data source would be to join the Individual record with the Seminar attendance record (joined on the Seminar description record if you have that in a separate table). I have a client who does seminars all over the world, and we use that approach for the report by person.
    Wendell

Posting Permissions

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