Creating a reporting system
Posted on February 03, 2007, under
ColdFusion
| 1504 Views
We use a open source PHP system called OpenBiblio for our library's card catalog. It has what I think is an outstanding feature for creating reports. You create an XML file and then drop it into the reportsdef folder. The system handles linking the reports on a master list and processing the report into html or pdf format.
<report>
<id>checkout_history</id>
<title>Checkout History</title>
<sql>
select biblio_copy.barcode_nmbr,
biblio.title,
member.barcode_nmbr,
member.last_name,
member.first_name,
biblio_status_hist.status_begin_dt,
biblio_status_hist.due_back_dt
from biblio_copy,
biblio,
biblio_status_hist,
member
where biblio_copy.bibid=biblio.bibid
and biblio_copy.bibid=biblio_status_hist.bibid
and biblio_copy.copyid=biblio_status_hist.copyid
and member.mbrid=biblio_status_hist.mbrid
and biblio_status_hist.status_cd='out'
</sql>
</report>
<id>checkout_history</id>
<title>Checkout History</title>
<sql>
select biblio_copy.barcode_nmbr,
biblio.title,
member.barcode_nmbr,
member.last_name,
member.first_name,
biblio_status_hist.status_begin_dt,
biblio_status_hist.due_back_dt
from biblio_copy,
biblio,
biblio_status_hist,
member
where biblio_copy.bibid=biblio.bibid
and biblio_copy.bibid=biblio_status_hist.bibid
and biblio_copy.copyid=biblio_status_hist.copyid
and member.mbrid=biblio_status_hist.mbrid
and biblio_status_hist.status_cd='out'
</sql>
</report>
Does this give you any ideas? Is anyone doing anything like this in coldfusion?
