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
Loading

anand kulkarniPosted Sep 1, 2014, 4:28 AM
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 <= ?text2.text " like this . And then Result will be displayed to the Sap Cry Reports .
This is the case .
Thanks In advance
regards
anand