Post Author: haggisns
CA Forum: Other
Hi,
I am changing a crystal report that is viewed using VB6 and the crysal report viewer control 9.
I have changed the connection in cyrstal report designer to use windows authentication based ODBC connection.
The old example I have to go by of the crystal report has the following behavior: When I click on the Show SQL Query from Database menuit pops up the "Enter Parameter Value" dialogue box with the 3 parameter fields of the report.
In the modified report I have which uses the ODBC connection instead of OLEDB, when I click on the Show SQL Query menu item it shows:
{CALL "teranet"."dbo"."zzzrpt_araging_by_gl_acct_sp";1('', '', {ts '2007-09-10 15:41:32'})}.
This is the stored procedure I want to use, but I want the VB6 to send the search parameters, I don't want them to be those as indicated in the statement above.
How do I modify the crystal report to accept parameters from the VB app. I already have the VB parameter code, it works with the old version of the crystal report but not with the newly modified one that has a trusted connection ODBC connection.
Thanks
Chris