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.<div><br></div><div>
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.</div>
<div><br></div><div>It would be very useful if we could do the date entry as done in the "/cgi-bin/koha/reports/<a href="http://borrowers_stats.pl">borrowers_stats.pl</a>" interface. That would be generic and dynamic as well. Is this possible with custom reports as well? </div>
<div><br></div><div>Please help.</div><div><br></div><div>Thankyou.<br><br><div class="gmail_quote">On Sun, Jan 10, 2010 at 5:30 AM, Nicole Engard <span dir="ltr"><<a href="mailto:nengard@gmail.com">nengard@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">This page in the manual might help you some:<br>
<a href="http://koha.org/documentation/manual/3.0/reports/custom-reports" target="_blank">http://koha.org/documentation/manual/3.0/reports/custom-reports</a> But<br>
it sounds to me like you're going to have to write your own SQL<br>
question and add ' WHERE 'datefield' BETWEEN 'date1' AND 'date2'.<br>
You can find some customer reports that others have written here:<br>
<a href="http://wiki.koha.org/doku.php?id=sql_library" target="_blank">http://wiki.koha.org/doku.php?id=sql_library</a><br>
<br>
Thanks<br>
Nicole<br>
<br>
2010/1/10 nitesh rijal <<a href="http://rijal.it" target="_blank">rijal.it</a>@<a href="http://gmail.com" target="_blank">gmail.com</a>>:<br>
<div><div></div><div class="h5">> Hello all.<br>
> I am trying to generate report of all the patrons who have enrolled between<br>
> certain date. I can see the date from and to in the inbuilt report formats,<br>
> but how do I use them in my custom reports?<br>
> My desired output is of form in table like:<br>
> [First Name Last Name Card Number]<br>
> but between certain date.....<br>
> Please Help.<br>
><br>
> --<br>
> Nitesh Rijal<br>
> BE IT<br>
> email: <a href="http://rijal.it" target="_blank">rijal.it</a>@<a href="http://gmail.com" target="_blank">gmail.com</a><br>
> url: <a href="http://niteshrijal.com.np" target="_blank">http://niteshrijal.com.np</a><br>
> facebook: <a href="http://facebook.com/openrijal" target="_blank">http://facebook.com/openrijal</a><br>
> twitter: <a href="http://twitter.com/openrijal" target="_blank">http://twitter.com/openrijal</a><br>
> +9779841458173<br>
><br>
</div></div>> _______________________________________________<br>
> Koha mailing list<br>
> <a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
><br>
><br>
</blockquote></div><br><br clear="all"><br>-- <br>Nitesh Rijal<br>BE IT<br>email: <a href="http://rijal.it">rijal.it</a>@<a href="http://gmail.com">gmail.com</a><br>url: <a href="http://niteshrijal.com.np">http://niteshrijal.com.np</a><br>
facebook: <a href="http://facebook.com/openrijal">http://facebook.com/openrijal</a><br>twitter: <a href="http://twitter.com/openrijal">http://twitter.com/openrijal</a><br>+9779841458173<br>
</div>