Continuation of the modification in the web application for adding the report by business unit using the kool report, the kool report is added, the query is created, the report columns of the report is created, test the modified web application to check if the added kool report is ok and if the expected report will be displayed, as per checking, when clicked the Report by Business Unit menu, the kool report does display, but it displayed all the data in table format and no filter has been applied to the report extracted all the data from the database. Checked on the internet on how to add the filter in the query and the filter selection using the kool report.
Modified the web application to create the report by business unit report same as how the report by PM ticket is created, checked the modified web application to see if the report will now display, as per checking, the report did display, added the selection for the business unit, the resources should be disabled while there is no selected business unit and brand is disabled while there are no resources selected if the brand is disabled the default selected value should be all brand, when the business unit selected in all, all the resources will be displayed but if a specific business unit is selected, the dropdown option will only be the resources under the selected business unit, all of this selection is existing and working, except to the business unit selection, checked the added dropdown for the business unit, as per checking, it is now displaying the business unit on the dropdown, modified the web application to apply the logic when the is selected business unit.