[Koha] How to add Date TO and FROM in custom reports

[nitesh rijal]

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 at 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
>
> 2010/1/10 nitesh rijal <rijal.it at 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 at gmail.com
> > url: http://niteshrijal.com.np
> > facebook: http://facebook.com/openrijal
> > twitter: http://twitter.com/openrijal
> > +9779841458173
> >
> > _______________________________________________
> > Koha mailing list
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
> >
>



-- 
Nitesh Rijal
BE IT
email: rijal.it at gmail.com
url: http://niteshrijal.com.np
facebook: http://facebook.com/openrijal
twitter: http://twitter.com/openrijal
+9779841458173
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100110/48690e43/attachment.htm