I am migrating my MS Access application to VB 6 due to its limitations with regards to my current project is concerned. How do I do (reporting) this with Crystal Reports 8.5 or later?

1. Report Graphs / Charts

Most of my reports in MS Access has Charts in it and its rowsource(queries) changes based on user input from the calling form when the report is loaded. Chart values changes based on user input.

Ex.
Form_Load()
OLEUnbound0.Rowsource = "SELECT DATE,A,B, C1, C2 " _
& "FROM TABLE " _
& "WHERE C1 IN('" & frmOne.txt1.Text & "') " _
& "AND C2 IN ('" & frmOne.txt2.Text '") " _
& "HavinG.... "

End Sub

Scenario:
txt1.Text and txt2.Text can be on or more values from multiselect listboxes

It's easy to do this in VB6 but how do I pass this (query) to my Crystal Reports and change the Chart results on runtime based on user input.