Hello:
I have a ODBC VB 6.0 project that has Dynamic SQL statments..the datasource has 12 tables and the user selects the table at run-time. I am still very new to Crystal Reports and I don't know how to handle this dynamic SQL in my Crystal Dsns..the VB aspect of this project is done.
How can I pass the month chosen on the VB form to the Crystal Reports at run-time(as in, use that table as the recordsource?). I have read on this board and other boards that a "stored procedure" might help with this...I have never done a stored procedure before, can someone help me. Is this the best solution for me? If so, can someone please post an example and the steps in creating one? Thank You
Martin K
I have a ODBC VB 6.0 project that has Dynamic SQL statments..the datasource has 12 tables and the user selects the table at run-time. I am still very new to Crystal Reports and I don't know how to handle this dynamic SQL in my Crystal Dsns..the VB aspect of this project is done.
How can I pass the month chosen on the VB form to the Crystal Reports at run-time(as in, use that table as the recordsource?). I have read on this board and other boards that a "stored procedure" might help with this...I have never done a stored procedure before, can someone help me. Is this the best solution for me? If so, can someone please post an example and the steps in creating one? Thank You
Martin K