[Koha-devel] Custom Reports

[Michael Hafen]

Perhaps something like:

SELECT br.branchname, b.title, b.author, it.description,
i.itemcallnumber, i.barcode, c.description, p.surname, p.firstname FROM
issues iss CROSS JOIN branches br USING (branchcode) CROSS JOIN items i
USING (itemnumber) CROSS JOIN biblio b USING (biblionumber) CROSS JOIN
itemtypes it ON i.itype = it.itemtype CROSS JOIN borrowers p USING
(borrowernumber) CROSS JOIN categories c USING (categorycode) ORDER BY
iss.branchcode;

On Thu, 2010-03-25 at 01:20 -0400, Claude Belizaire wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>  
> Hello all,
> 
> Can someone help me? I need the SQL query that would generate a report
> listing checked-out items by location.
> 
> Cheers,
> Claude
> 
> 
> Le 2010-03-25 01:02, Claude Belizaire a écrit :
> > Thanks for the quick reply, I have looked at the link you sent. It
> > has lots of custom queries but I would need more time then I have
> > to complete the reports.
> >
> > I was able to generate a report from on of the koha demo but I
> > would really appreciate tips help building those custom reports.
> >
> > I would be happy to make a donation through paypal in exchange for
> > some help. :-)
> >
> > Cheers, Claude
> >
> > Le 2010-03-25 00:44, Nicole Engard a écrit :
> >> Some of these types of reports can be found on the wiki:
> >> http://wiki.koha.org/doku.php?id=sql_library
> >
> >> You can also request new reports on that page.
> >
> >> Thanks Nicole C. Engard
> >
> >> On Wed, Mar 24, 2010 at 11:49 PM, Claude Belizaire
> >> <claude.belizaire at sys-tech.net> wrote: Hello all,
> >
> >> I am building custom reports in Koha and I am having some
> >> troubles getting the right results when creating custom
> >> definitions.
> >
> >> 1. Acquisitions by status (ordered, received, processed, new
> >> releases)
> >
> >> 2. A detailled budget report
> >
> >> 3. Circulation by patron categories.
> >
> >> 4. Checked-out items by location.
> >
> >> Can anyone help me?
> >
> >> Regards, Claude
> >>>
> > _______________________________________________ Koha-devel mailing
> > list Koha-devel at lists.koha.org
> > http://lists.koha.org/mailman/listinfo/koha-devel
> >>>
> >
> 
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel
> 
> - -- 
> *Claude Bélizaire*
> Chef d`équipe Web
> 
> claude.belizaire at sys-tech.net <mailto:claude.belizaire at sys-tech.net>
> 418 520-0739 poste 140
> 514 907-0036 / 1-877-969-8324
> 
> *SYS-TECH / Technologies de l'information libres*
> 6700 BOUL PIERRE-BERTRAND BUREAU 209
> QUÉBEC QC G2J 0B4
> http://www.sys-tech.net
> 
> /Membre supporteur de l'Association TYPO3 <http://typo3.org>/
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>  
> iQEcBAEBAgAGBQJLqvK7AAoJEDbGJ8QX4NMpfVEH/26ew/FaBHS1IN6UnKMTC4rN
> wy13drkkvd21esxhhg0HYg0C5pio/qgVIzxOBv9cbKolRj02Wwg1thVIycJMtvdO
> gm0R5Bzxr2lC1O42qiCOxAIlkOuV8Ss/0qSq/BktsebClsKSWPgFOZoIUUNk4I/n
> xVjPWUiboRkvGLv/B/vGftIEVBRMHchw/rlIMdgOaCARPpSv3jOoC59QLPJljuaR
> rCjMMtdiCU7SbBGGZkN3bQVMsCrnidBRmqODECrafIqT0C4iQF4OtuG+8DUKE9zD
> s1wTS0JHE7RtOJwORGsw5KLCMAPK8D2RCG0QvzbWFJCliBUrHqpal1GI6SWDoHs=
> =8NkZ
> -----END PGP SIGNATURE-----
> 
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel


-- 
Michael Hafen
Systems Analyst and Programmer
Washington County School District
Utah, USA

for Koha checkout
http://development.washk12.org/gitweb/
or
git://development.washk12.org/koha