Feb 03
Creating a reporting system
Comments (1) || ColdFusion 1016 ViewsWe 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?
6/2/07 2:27 PM
Inevitably, once a client asks for one report they will constantly be asking for more. "It would be really nice if..."
Lately I've been thinking about how to build a reporting engine for one of our clients. The OpenBiblio reporting is really interesting! It would also need it to be able to join multiple database table and dynamically filter results based on user input.
Been working with Transfer ORM framework and it has a nice XML file configuration where you relate database tables and fields. Maybe a good method to use here.