Query report for filters

i have create the simple query report with filter but the filter doent carry any values. it show s blank.
the date range is working but company not showing values
SELECT
si.item_code AS ‘Item Code’,
si.item_name AS ‘Item Name’,
si.qty AS ‘Quantity’,
si.net_amount AS ‘Net Value’,
s.customer AS ‘Customer’,
s.company AS ‘Company’
FROM
tabSales Invoice Item si
JOIN
tabSales Invoice s
ON
si.parent = s.name
WHERE
s.posting_date BETWEEN %(from_date)s AND %(to_date)s
AND s.company = %(company)s;

Hi @Rajkumudu_Rk,

Please check the post.

Thank You!

I did exactly what you showed. But it didn’t work. I gave customer name directly and it works. When filtering it shows nothing.


Hi @Rajkumudu_Rk,

Why use a select field type for company?

Please set the Link field type and also add the option “Company” in the company filter.
After then reload and check it.

Thank You!

Nothing Change



Hi @Rajkumudu_Rk,

Please check it.

SELECT
    si.item_code AS 'Item Code',
    si.item_name AS 'Item Name',
    si.qty AS 'Quantity',
    si.net_amount AS 'Net Value',
    s.customer AS 'Customer',
    s.company AS 'Company'
FROM 
    `tabSales Invoice` s, 
    `tabSales Invoice Item` si
WHERE
    si.parent = s.name
    AND s.posting_date BETWEEN %(from_date)s AND %(to_date)s
    AND s.company = %(company)s;

Thank You!

1 Like

It works
Thank you indeed. I have no words to thank you