Hello Everyone,
I created two Query Reports as below.
Ref. Doctype : Salary Slip
Is Standard : No
Report 1
SELECT
employee_name AS "Employee:Data:200",
bank_name AS "Bank Name:Data:150",
bank_account_no AS "Bank Account Number:Data:200",
net_pay AS "Amount:Currency:150"
FROM
`tabSalary Slip`
WHERE
docstatus = 1 AND start_date = %(start)s AND net_pay > 0 AND custom_employment_type = "Staff - Registered" OR docstatus = 1 AND start_date = %(start)s AND net_pay > 0 AND custom_employment_type = "Worker - Registered"
Report 2
SELECT
employee_name AS "Employee Name:Data:300",
employee AS "Employee:Data:150",
absent_days AS "Absent Days:Data:150",
net_pay As "Net Pay:Currency:200"
FROM
`tabSalary Slip`
WHERE
(docstatus = 1 AND start_date = %(start)s AND net_pay > 0) AND custom_employment_type = 'Staff - Unregistered' OR custom_employment_type = 'Worker - Unregistered'
In First Report First Column “Serial Number” is showing correctly.
But in “Report 2” Column width gets small, and numbers gets hide.
