[Koha] Report help

[David Hughes]

Thanks so much Caroline.  Perhaps I should look at the statistics wizards
more often!

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/>*

On 3 August 2018 at 18:29, Caroline Cyr-La-Rose <
caroline.cyr-la-rose at inlibro.com> wrote:

> 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
> inLibro | pour esprit libre | 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/> <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.