[Koha] Report help

[Caroline Cyr-La-Rose]

Hi David,

Did you try with the statistics wizards? If you go in Reports > 
Statistics wizards > Patrons and then choose your first attribute "CC" 
as a row and "CD" as a column, it should give you a table with all the 
different combinations and the count of patrons with that combination.

Caroline

Caroline Cyr La Rose, M.S.I.
Bibl. prof. / Chargée de la formation et du soutien

Tél.  : 1 (833) 465-4276
caroline.cyr-la-rose at inLibro.com <mailto:caroline.cyr-la-rose at inLibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Le 2018-08-03 à 11:57, David Hughes a écrit :
> 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/>*
>