How to add Date TO and FROM in custom reports
Hello all. I am trying to generate report of all the patrons who have enrolled between certain date. I can see the date from and to in the inbuilt report formats, but how do I use them in my custom reports? My desired output is of form in table like: [First Name Last Name Card Number] but between certain date..... Please Help. -- Nitesh Rijal BE IT email: rijal.it@gmail.com url: http://niteshrijal.com.np facebook: http://facebook.com/openrijal twitter: http://twitter.com/openrijal +9779841458173
This page in the manual might help you some: http://koha.org/documentation/manual/3.0/reports/custom-reports But it sounds to me like you're going to have to write your own SQL question and add ' WHERE 'datefield' BETWEEN 'date1' AND 'date2'. You can find some customer reports that others have written here: http://wiki.koha.org/doku.php?id=sql_library Thanks Nicole 2010/1/10 nitesh rijal <rijal.it@gmail.com>:
Hello all. I am trying to generate report of all the patrons who have enrolled between certain date. I can see the date from and to in the inbuilt report formats, but how do I use them in my custom reports? My desired output is of form in table like: [First Name Last Name Card Number] but between certain date..... Please Help.
-- Nitesh Rijal BE IT email: rijal.it@gmail.com url: http://niteshrijal.com.np facebook: http://facebook.com/openrijal twitter: http://twitter.com/openrijal +9779841458173
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
I knew that we can enter the dates manually, but just was wondering whether that can be done dynamically through the date picker, because the report we need to generate depends on the year of enrollment. May be we generate reports for patrons who enrolled this year, and then in the next lot we want to generate the report for patrons who enrolled the previous year, this could be definitely done by writing the dates manually, but it has to be changed everytime we change the lot of patrons. It would be very useful if we could do the date entry as done in the "/cgi-bin/koha/reports/borrowers_stats.pl" interface. That would be generic and dynamic as well. Is this possible with custom reports as well? Please help. Thankyou. On Sun, Jan 10, 2010 at 5:30 AM, Nicole Engard <nengard@gmail.com> wrote:
This page in the manual might help you some: http://koha.org/documentation/manual/3.0/reports/custom-reports But it sounds to me like you're going to have to write your own SQL question and add ' WHERE 'datefield' BETWEEN 'date1' AND 'date2'. You can find some customer reports that others have written here: http://wiki.koha.org/doku.php?id=sql_library
Thanks Nicole
Hello all. I am trying to generate report of all the patrons who have enrolled between certain date. I can see the date from and to in the inbuilt report
2010/1/10 nitesh rijal <rijal.it@gmail.com>: formats,
but how do I use them in my custom reports? My desired output is of form in table like: [First Name Last Name Card Number] but between certain date..... Please Help.
-- Nitesh Rijal BE IT email: rijal.it@gmail.com url: http://niteshrijal.com.np facebook: http://facebook.com/openrijal twitter: http://twitter.com/openrijal +9779841458173
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Nitesh Rijal BE IT email: rijal.it@gmail.com url: http://niteshrijal.com.np facebook: http://facebook.com/openrijal twitter: http://twitter.com/openrijal +9779841458173
participants (2)
-
Nicole Engard -
nitesh rijal