Report Groupings

Topic

New Reply

Hi, I have a ‘table 1’ with a one to many with ‘table 2’ which has a a one to many with ‘table 3’. I have a query that includes all the records, so say if client in table is smith and he has two accounts in table 2 and three transactions in table 3 on each of those accounts, then when I run the query there are 6 lines returned, which is what I require. I am now building a report which I need to structure as the tables show, so a grouping with client (1 entry), a grouping with account s(listing two accounts) and a seperate 3rd groping showing 6 transactions. I am struggling to get this to work in my report. Any guidance is welcomed.

Thanks, Darren

Reply | Quote

Replies

So you do *not* want to group the accounts by client, and do *not* want to group the transactions by account.
In that case, I’d create three separate reports, one for each of the tables, and place them below each other as subreports in the detail section of a fourth, unbound report.

Reply | Quote

Hi, I have a ‘table 1’ with a one to many with ‘table 2’ which has a a one to many with ‘table 3’. I have a query that includes all the records, so say if client in table is smith and he has two accounts in table 2 and three transactions in table 3 on each of those accounts, then when I run the query there are 6 lines returned, which is what I require. I am now building a report which I need to structure as the tables show, so a grouping with client (1 entry), a grouping with account s(listing two accounts) and a seperate 3rd groping showing 6 transactions. I am struggling to get this to work in my report. Any guidance is welcomed.

I interpret your question differently to Hans.
I think you need two levels of grouping… not three. Group by Client, then by Account, then put the transaction specific fields in the Details section.
For each of the Groupings create a Header, and put the fields specific to that level in the Header.

Reply | Quote

I interpret your question differently to Hans.
I think you need two levels of grouping… not three. Group by Client, then by Account, then put the transaction specific fields in the Details section.
For each of the Groupings create a Header, and put the fields specific to that level in the Header.

Thank you gents, I can see the ambiguity in my post. I did mean as John interpreted.

Thanks to you both and apologies for my delay.

Darren

Reply | Quote