Accessing checkbox in filters for queryreport

[NCP]

Please check it.

Adding Filters in Query Report

Hi @DME_Apaulsoftware, In query report, if you add filter then run the report keyerror show so cancel the error and enter the MR Number/name then check otherwise mandatory set in filter for a name then check your report. The filter-wise report will work on the server script report. https://frappeframework.com/docs/v13/user/en/desk/reports/script-report Thanks.

Adding Filters in Query Report

Hi @DME_Apaulsoftware, Please check this. [image] Output: When you select MR ID then will be show data. [image] Sample code: SELECT `tabMaterial Request`.`name` as `MR:Link/Material Request:180`, `tabMaterial Request`.`transaction_date` as `Transaction Date:Date:120`, `tabMaterial Request`.`status` as `Status:Data:100` FROM `tabMaterial Request` WHERE `tabMaterial Request`.`name` = %(name)s AND `tabMaterial Request`.docstatus = 1 T…