Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have posted on a similar theme a little earlier but I am still struggling, none the less...I have a main report, say A, within it a sub say B and within B a sub say C. Within A, I have two grouping levels, sales agent and team. I need within report A to be able to show the type of sales as a count that each agent has achieved and overall for the report in A, thus the team. So say in sub B that there are two sale type, 1 and 2 and agent xxx in report A has one of each sale, i need a total in A to show agent xxx has 1 sale of 1 and 1 sale as 2 then to total these for these team. i am struggling to understand where I need to put text boxes and what code i need to enter in them.

    Many thanks, Darren.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    This is getting rather confusing; the descriptions seem to change each time.
    Could you provide a clear, precise and comprehensive description instead of just a vague general one, and/or post a stripped down and zipped copy of the database, so that we get an idea of what you're actually working with?

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' date='26-Jun-2009 01:36' post='781824']
    This is getting rather confusing; the descriptions seem to change each time.
    Could you provide a clear, precise and comprehensive description instead of just a vague general one, and/or post a stripped down and zipped copy of the database, so that we get an idea of what you're actually working with?

    So sorry, this is the earlier post for which you gave me a fantastic answer that enabled to build the reports a I needed:

    "I have a main table with say main ID, from this I have a many scheme table with schemeID. Scheme has two many to many relations with risks and checks. I have created appropriate junction tables for each. I have combined all these in one query to show all records."

    What I now wish to do is total the number of risks and checks at scheme level and then overall at the main level on the top parent report.

    Hope this make sense.

    Thank you, Darren.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    In the earlier topics we ended up with a main report with two subreports in the detail section, i.e. the subreports are at the same level, immediately below the main report.
    Now you're mentioning a main report, a subreport within the main report and a sub-subreport within the subreport.
    That's what confuses me, and why you will need to provide much more and much clearer information.

  5. #5
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='781857' date='26-Jun-2009 10:03']In the earlier topics we ended up with a main report with two subreports in the detail section, i.e. the subreports are at the same level, immediately below the main report.
    Now you're mentioning a main report, a subreport within the main report and a sub-subreport within the subreport.
    That's what confuses me, and why you will need to provide much more and much clearer information.[/quote]

    Ok Hans, I'll send a stripped down version once I return home.

    Thanks again, Darren.

Posting Permissions

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