How query based develop vendor rating report
I'm trying to develop, vendor rating report.
Please help me to developing report.
Parameter : Vendor Name wise
S.no Period GRPO QTY Accepted QTY No. of delay Quality
Period : 01/04/2015 to 30/06/2015
Example : GRPO QTY : 100
Accepted QTY : 50
Delay : Posting Date due date - GRPO Posting Date
Please provide query