Column "Serial Number" in Query Report

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.

1 Like