Hi everyone,
I have 1 problem need your idea. I have 1 report that have 3 parameters ( From Month, To Month and Year). My report will display between From Month and To Month of year only. ex: From Month=Apr and To Month=June==> My report will display Apr May and Jun.
I use Javascript with Jquerty to hide like this:
$.each($("#product>tbody>tr:gt(0)"), function (i, v) {
$.each($(v).find("td").slice(1, start), function (i1, v1) {
$(v1).css("display", "none");
});
});
$.each($("#product>tbody>tr:gt(0)"), function (i, v) {
$.each($(v).find("td").slice(end, 37), function (i1, v1) {
$(v1).css("display", "none");
});
});
After i used this code, my report display correctly. it means that it displays between From Month and To Month.
But when i export to excel, It still display 12 months. It means that in excel is not the same with report form. like example above: The report displays Apr May Jun ( Correct) but In Excel, it displays 12 months (start from Jan to Dec) ( Incorrect). the correct in excel should be displayed Apr May Jun ( the same col with report).
So Does anybody know how i can remove col of html's table using javascript or jquery to remove unused month?
Note: in my sql, it already has 12 months
Thanks