Try ERPNext Buy Support Partners Foundation

Column wise date range in query report

actually I make a month-wise query report but didn’t set report …

SELECT `tabSales Invoice Item`.`item_code` as `item::150`,

SUM(qty) AS Total QTY::100,
SUM(amount) - posting_date between “2020-04-01” and “2020-04-30” AS APR SALES:Float:100,

SUM(amount WHEN posting_date >= ‘20200401’ AND posting_date < ‘20200430’ THEN 1 END) AS April:float:100,

SUM(amount) AS MAY SALES:Float:100,
SUM(amount) AS JUN SALES:Float:100,
SUM(amount) AS JUL SALES:Float:100,
SUM(amount) AS AUG SALES:Float:100,
SUM(amount) AS SEP SALES:Float:100,
SUM(amount) AS OCT SALES:Float:100,
SUM(amount) AS NOV SALES:Float:100,
SUM(amount) AS DEC SALES:Float:100,
SUM(amount) AS JAN SALES:Float:100,
SUM(amount) AS FEB SALES:Float:100,
SUM(amount) AS MAR SALES:Float:100,
SUM(amount) AS Total Amount:Float:100

FROM tabSales Invoice Item,tabSales Invoice

where
tabSales Invoice Item.parent = tabSales Invoice.name
and tabSales Invoice.docstatus = 1

	Group by `item_code`

thanks.