Reports/
From PikaDocs
- MegaReport : How to make the most of the MegaReport Tool
- Making your own Pika reports
- Iowa's collection of custom reports
Miscellanous Report Tips:
- Use the phrase WHERE 1 in your SQL when you need a placeholder for the WHERE clause that is always true.
- Here's how to create a menu in your reportname-form.php file:
$a['close_code_menu'] = pl_html_menu(pl_menu_get('close_code'), 'close_code', 'N', 1, 1);
the parameters of pl_html_menu are: array of values, name of field, default value, whether to show a blank value (1 is yes, 0 is no, and what the number of the field's tabindex should be
- Good report tip from Bryan Baker:
> -----Original Message-----
> From: Bryan Baker
> Sent: Wednesday, January 18, 2006 12:00 PM
> To: Pika Listserv
> Subject: [Pika Users] Quick tip for report forms
>
>
> To have a default date range filled in automagically in your
> forms (esp
> handy for yearly reports due in Jan):
>
> Place:
> $a['year'] = date("Y", mktime(0, 0, 0, date("m"), date("d"),
> date("Y")-1));
>
> into your <repname>-form.php file to populate the template variable
> "year" with last year.
> and replace the part of the input box html for that form element that
> is the string literal for the year with %%[year]%%
>
> <input type=text name=date_end value="12/31/%%[year]%%" size=12
> tabindex=1><br>
>
> was just adapting a report I've been doing once a year as a std pika
> report and thought this might be useful.
>
>
> If you want year to be this year instead, use:
> $a['year'] = date("Y");
>
> in your <repname>-form.php file.
>
> this all just makes things a little bit easier on the user, and it's
> not that hard (I get tired of changing all those 2003's).
>
