controls, counts, reports and sub reports

Topic

New Reply

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.

Reply | Quote

Replies

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?

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

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

Thanks again, Darren.

Reply | Quote