Passing mysq query and run cryreport

Question

Hello All Experts
I Have Connected to C# + Mysql useing dsnless connection . Every thing is fine and thank you .
Now days I am trying to run a crystal report .
I have installed cry report .
I have made another report viewer form .
I have created a crystal report .
at the time of creating cry report i have set the query and with that query cry report runs without error . Even am calleing the the report viewer form with out error .
BUT
I want to make some changes in above method
1 . I want to pass the query to the cry report after taking inputs from user like from date , To Date .
2 after taking inputs from user . It should run the query useing user inputs. and pass them to the another form for viewing cry report output .
Hope you can understand . Thanking you in Advance .
anand

anand kulkarni · Answer

Hello  I am useing DSN Less Mysql odbc connection . Connection is working fine . No issues about the connectivity . What I want to say is When user Click some text box value . Get that value and pass a mysql queri . Same should be assigened to the crystal report data source . How it can be done . Mean to say that If user want to get the Accounts Open from 01-01-2013 to 31-01-2013 . then user will open that report form will enter the from and to date at the Run Report Button click Mysql queri will be executed like  Select *from acop where acopdt >= ?text1.text and acopdt This is the case . Thanks In advance regards anand