Hi..
I have a new situation here...with CR 11 and VB6
==============================================
CRYSTAL REPORT 11 Report Designer part
==============================================
I have designed my report in Crystal Report 11 product using the Report Designer. And i have NOT used the standard wizard that pops up for designing the reports.
STEP 1:
I have opened a blank report and used the Database Expert tool for connecting my MS ACCESS (.MDB) database file and also selected the tables that would be used in report generation.
STEP 2:
Dragged & dropped the fields from the Feild Explorer's database tables and placed it on the Report Designer window. Like this i have designed my reports.
STEP 3: Saved the report as .RPT extension
==============================================
Visual Basic 6 Code View part
==============================================
STEP 1:
In VB6 code, i have used the ".SQLQueryString" property
SYNTAX: ".SQLQueryString <string_variable>"
NOTE: the string variable contains the SQL query statement.
STEP 2:
setting report location:
SYNTAX: ".OpenReport(App.Path & "\ABC.rpt")"
STEP 3:
setting .MDB database location:
SYNTAX: ".Database.SetDataSource (App.Path & "\XYZ.mdb")"
STEP 4: There is some other code also. Main thing is that now my reports are being generated perfectly using the user selected item from a combo box's dropdownlist on a vb form window.
QUESTIONS:
========
1. I will be adding the CR11 Merge Modules to my setup builder, as given on the Business Objects site.
Now, if i do the things as stated above. Then will i be able to deploy & view my reports at the client's end/end-user's computer without
installing the Crystal Report 11 product there ??
Awaiting reply...