[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

***@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.




_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lists.katipo.co.n

[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.  : [phone]
caroline.cyr-la-***@inLibro.com <mailto:caroline.cyr-la-***@inLibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>

Post by 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
*http://library.dbs.ie <http://library.dbs-students.com/>*

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
http

[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

***@dbs.ie
*http://library.dbs.ie <http://library.dbs-students.com/>*

On 3 August 2018 at 18:29, Caroline Cyr-La-Rose <

Post by 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. : [phone]
inLibro | pour esprit libre | www.inLibro.com
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
*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.




_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.n