Problem:- 


If we generate Machine running hours report, report shows full (all year) data instead of selected dates.



Solution:- 



1. We take server access then we take database back up.

2. Then we execute below query.

 


UPDATE report_template_params SET TABLE_COLUMN_ID = 954 WHERE REPORT_TEMPLATE_ID = 106 AND PARAM_ID = 4001;
UPDATE report_template_params SET TABLE_COLUMN_ID = 954 WHERE REPORT_TEMPLATE_ID = 107 AND PARAM_ID = 4001;