Hi,
Now I Am create a new query report to filter the data for one month…Already i am wrote query but its has some error…I want To filter the data by Posting date…
select
`tabSales Invoice`.`employee_name` as "Employee Name:Read Only:100",
`tabSales Invoice`.`posting_date` as "Date:Date:100",
`tabSales Invoice Item`.`qty` as "Quantity:Float:100",
`tabSales Invoice Item`.`rate` as "Rate:Currency:100",
`tabSales Invoice Item`.`amount` as "Amount:Currency:100",
`tabInput Filter`.`transcation` as "Transcation:Data:100",
from
`tabSales Invoice`, `tabSales Invoice Item`, `tabInput Filter`
where
`tabSales Invoice Item`.parent = `tabSales Invoice`.name
and `tabSales Invoice`.`docstatus` = "1"
and `tabSales Invoice`.`posting_date` between `tabInput Filter`.`from date` and `tabInput Filter`.`to date`
group by `tabSales Invoice`.'employee_name'
select
`tabSales Invoice`.`employee_name` as "Employee Name:Read Only:100",
sum(`tabSales Invoice Item`.`qty`) as "Quantity:Float:100",
sum(`tabSales Invoice Item`.`amount`) as "Amount:Currency:100",
`tabInput Filter`.`transaction` as "Transaction:Data:250"
from
`tabSales Invoice`, `tabSales Invoice Item`, `tabInput Filter`
where
`tabSales Invoice Item`.parent = `tabSales Invoice`.name
and `tabSales Invoice`.`docstatus` = "1"
and `tabInput Filter`.`docstatus` = "1"
and `tabSales Invoice`.`posting_date` between `tabInput Filter`.`from_date` and `tabInput Filter`.`to_date`
group by `tabSales Invoice`.`employee_name`