Add the below script to your html header to add date range above.
<script> function defDates() { if (document.acthist.date_range[acthist.date_range.selectedIndex].text == "All Dates") { document.acthist.start_date.value="01/01/1900"; document.acthist.end_date.value="12/31/2099 "; }; if (document.acthist.date_range[acthist.date_range.selectedIndex].text == "Today") { document.acthist.start_date.value="@var_data_date_@"; document.acthist.end_date.value="@var_data_date_@"; }; if (document.acthist.date_range[acthist.date_range.selectedIndex].text == "Date Range") { document.acthist.start_date.value="@var_start_date_@"; document.acthist.end_date.value="@var_end_date_@"; }; if (document.acthist.date_range[acthist.date_range.selectedIndex].text == "Last 7 Days") { document.acthist.start_date.value="@var_minus7_@"; document.acthist.end_date.value="@var_data_date_@"; }; if (document.acthist.date_range[acthist.date_range.selectedIndex].text == "Last 30 Days") { document.acthist.start_date.value="@var_minus30_@"; document.acthist.end_date.value="@var_data_date_@"; }; } </script> <script> function setupCalendar() { StartCal = new dhtmlxCalendarObject("startdt"); StartCal.setDateFormat("%m/%d/%y"); StartCal.setSkin("dhx_blue"); //StartCal.isWinHeader(true); //StartCal.isWinDrag(true); StartCal.draw(); EndCal = new dhtmlxCalendarObject("enddt"); EndCal.setDateFormat("%m/%d/%y"); EndCal.setSkin("dhx_blue"); //EndCal.isWinHeader(true); //EndCal.isWinDrag(true); EndCal.draw(); } </script>
Add this form to your script to run a request and pass to it a beginning and ending date range: @var_start_date and ending date range @var_ end_date
<form name="acthist" method="POST" action="http://@var_form_action_url_@"> <select size="1" name="date_range" onclick="defDates()"> <option value="Today">Today</option> <option value="Last 7 Days">Last 7 Days</option> <option value="Last 30 Days">Last 30 Days</option> <option value="All Dates">All Dates</option> <option value="Date Range">Date Range</option> </select> <input type="text" id="startdt" name="start_date" size="10" value="@var_start_date_@"> thru <input type="text" id="enddt" name="end_date" size="10" value="@var_end_date_@"> <br> <input type="submit" value="Submit" onClick="document.getElementById('rmarea').innerHTML = 'Loading...'"> <input type="hidden" name="operator" value="@var_operator_@"> <input type="hidden" name="session_no" value="@var_session_no_@"> <input type="hidden" name="request_id" value="wicusacthist"> <input type="hidden" name="cust_no" value="@var_cust_no_@"> <input type="button" name="a1" value="Show pivot" onclick="mygrid1.makePivot()"><input type="button" name="a1" value="Hide pivot" onclick="mygrid1.hidePivot()"><br> </form>
Cust and paste this area into your html document for the ability to choose a date range for your RM report. Replace the request_id value wicusacthist with the NL request you want to run. Add or delete hidden variables as needed.
RM Area
<div id="rmarea"> @var_include_rm1_@ </div>
Include this area to your form - t
Pivot Area