Guest_imported
New member
- Jan 1, 1970
- 0
I have crystal report, designed in CrystalReport Developer v 8.5. Source of data is stored procedure from SQL Server 7.0 database. "File - Save Data with Report" unchecked, "Database - Verify on Every Print" - checked. When creating report I assigned SQL Server name, database name and stored procedure manually (DataBase, SetLocation, ...). I developed little vb 6.0 application, that use crystl32.ocx control to run report.
Since application will be distributed to users, that will have different names of SQL Servers, I need to set SQL Server name from my VB application. Using Connection property will not affect report. It is still using original settings, that I assigned manually in CrystalReport developer environment. Second question - how can I force CR to use new (for example updated) stored procedure. What property or method allow me set stored procedure name? SQLQuery does nothing. Please, help.
Thanx
Since application will be distributed to users, that will have different names of SQL Servers, I need to set SQL Server name from my VB application. Using Connection property will not affect report. It is still using original settings, that I assigned manually in CrystalReport developer environment. Second question - how can I force CR to use new (for example updated) stored procedure. What property or method allow me set stored procedure name? SQLQuery does nothing. Please, help.
Thanx