I need your help, I try to integrate two datepickers (vStartDate and vEndDate) in a report in order to allow my users to select the period they want to analyze and re-run the report with these new parameters. I've tried to let the default report parameter fields using the dbr.parameters.show command but it doesn't fit our graphics requirements.
So I try now to run this report using an html form into the report himself. The display is good, but as soon as I change the date in the input box and clic on submit, I'm immediately redirected to the myDBR home page instead of our report.
Does someone can help me please ?
My code is :
CREATE PROCEDURE `sp_DBR_period_counter`( vStartDate date, vEndDate date ) BEGIN
select 'dbr.title',concat('COUNTERS between ',vStartDate,' and ',vEndDate); select 'dbr.html', concat('<FORM action="report.php" method="get"><input id="r" type="hidden" value="62"><DIV class="title">COUNTERS between <input id="u1" name="u1" type="date" value="',vStartDate,'"> and <input id="u2" name="u2" type="date" value="',vEndDate,'"><input type="submit" class="runreport button sub_button"><input id="m" type="hidden" value="19"><input id="h" type="hidden" value="e6f4aa0483ce543739c141e162446cf0510ac0a9"></FORM>');
select * from mytable when mydate >=vStartDate and mydate <= vEndDate;