Add a FORM to a specific report

[zineb]

Hi all,

I am trying to add a FORM to a report where user have to insert two
date times
Example:

Choose delivery date between: DD/MM/YYY and DD/MM/
YYYY Submit

I would like to get those two values and insert them into the sql
query which permits to create the report.

I tryed using this condition in my query :
AND (c10.value between 'date_start' and '.date_end' ) ( c10.value is
my the delivery date)

But it doesn't work.

Please could you help me?????

Thanks,

Zineb

[Noah Kantrowitz]

You would have to make a custom plugin to do this.

--Noah

[Erik Bray]

It's not entirely clear what the OP's end goal is, but it might be
possible to just do with a custom report, especially since #7293.
Have two dynamic variables for the dates, and make sure that in the
SQL the variables are wrapped in the appropriate datetime formatting
function for the DB backend. Not clear if that's what he wants
though.

[zineb]

Thanks a lot, that's exactly what i wanted.
i have finally find a way to do it by only changing report_view file.
i created a form which allows to get the two dynamics variable and
pass them throught the URL.
now i have a small problem with the date format (years are not
considered into the comparaison)..
I will look into the tickets to make my solution more efficient.

Thanks again

On Jun 25, 3:11 pm, Erik Bray <hyugaricd...@gmail.com> wrote:
> It's not entirely clear what the OP's end goal is, but it might be
> possible to just do with a custom report, especially since #7293.
> Have two dynamic variables for the dates, and make sure that in the
> SQL the variables are wrapped in the appropriate datetime formatting
> function for the DB backend.  Not clear if that's what he wants
> though.
>