If you can manage to get all the required data into just the one single report, you can specify a group range in the crosstab.
If you have the 'customer.name' in the Row section & the '.date' field in the Column section, this will do what im thinking you are wanting it to do...
When the date...
Thanks guys,
I used the "distinctcouont({transaction_ID},Client.Ref})" formula and this worked absolutely fine.
I was missing the distinct count and the ID field as some dates were the same, meaning when i used the .when, it counted them incorrectly.
Thanks
Right,
I have 2 tables linked together in the same report.
Table one contains all the payments made to the company as Fees.
Table two contains all the disbursements made to the creditors.
When i try to count to Fee Payments & the Disbursements seperately...i get a grand total of the 2...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.