[Koha] Report help

[David Hughes]

Hi,

I want to create a report that gives a grand total of records with various
combinations of two different patron attributes.

I have two different borrower_attributes.code values "CC" and "CD" and I
want to output the grand totals of records with all permutations of
borrower_attributes.attribute that have these codes.  So if
borrower_attributes.code CC has values 1, 2, 3 etc and
borrower_attributes.code CD has values A, B C  I'd want to output the grand
totals of all records having

CC value "1" CD value "A"
CC value "1" CD value "B"
CC value "1" CD value "C"
......
CC value "2" CD value "A"
CC value "2" CD value "B"

etc

This is outwith the scope of my very limited SQL, so I'd appreciate any
help that the community would be able to offer.  Thanks.

Kind regards

David Hughes

Systems Librarian
Dublin Business School
13-14 Aungier St.
Dublin 2
Ireland

00 353 1 417 8744

david.hughes at dbs.ie
*http://library.dbs.ie <http://library.dbs-students.com/>*

-- 


*Data Protection: *The protection of your data is important to us.  
Please see our Privacy Notice <https://www.dbs.ie/privacy-policy> for more 
information on how we handle your data.