bar graph and query

hi,
pls visit for more info, based on the same query
https://www.experts-exchange.com/questions/21781980/bar-graph-and-how-to-write-a-query-in-ms-access-vb-net-crystalreports.html

SELECT A.ityp_id, B.YearMonth, IIf(IsNull(B.CountOfinsp_id),0,B.CountOfinsp_id) AS CountOfinsp_id
FROM InspectionType AS A LEFT JOIN [SELECT     InspectionType.ityp_id,
                     Format(Inspection.insp_DateTime, "yyyy/mm") AS YearMonth,
                     COUNT(Inspection.insp_id)  AS CountOfinsp_id
          FROM       (((((Sector
                     INNER JOIN Building
                            ON Sector.sect_id = Building.sect_id)
                     INNER JOIN InspectionUnit
                            ON Building.buil_id = InspectionUnit.buil_id)
                     INNER JOIN Inspection
                            ON InspectionUnit.unit_id = Inspection.unit_id)
                     INNER JOIN InspectionSchedule
                            ON Inspection.sinp_id = InspectionSchedule.sinp_id)
                     INNER JOIN InspectionType
                            ON InspectionUnit.ityp_id = InspectionType.ityp_id
                            AND InspectionSchedule.ityp_id = InspectionType.ityp_id)
          WHERE      Format(Inspection.insp_DateTime, "yyyy/mm") BETWEEN '2005/12' And '2006/02'
          GROUP BY InspectionType.ityp_id, Format(Inspection.insp_DateTime, "yyyy/mm")
]. AS B ON A.ityp_id = B.ityp_id;

----
the above query works fine
iam having a form vb.net

and iam having a textbox [ending date]  value is 19-Mar-01
and a Drop Down box choosing [weekly or fortnightly,Monthly]value is Weekly
and a drop down box using value  is 3

pls help me to change above query in the crystal report to generate a bar graph, that can work weekly, fortnighly & Monthly

if let say i choose weekly
the value should appear(ityp_id) items in bar graph
the dates  should get in legend below chart

27/02/2006 - 05/03/2006                    
06/03/2006 -12/03/2006
13/03/2006-19/03/2006

If let say i choose Fortnightly

06/02/2006 - 19/02/2006
20/02/2006 - 05/03/2006
06/03/2006 -09/03/2006

if let say i choose monthly
12/2005
01/2006
02/2006

all must be  dynamic parameters
1. monthly,fortnightly, or weekly (dropdown)
2. No of months/week(3,4,5) (dropdown)
3. Ending date can change (textbox)

waiting for your reply