|
-
Mar 22nd, 2007, 11:41 AM
#1
Thread Starter
Member
[RESOLVED] CR11 issue...please verify for deployment purposes....
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...
Last edited by intellogo; Mar 23rd, 2007 at 07:41 AM.
Regards,
intellogo
-
Mar 23rd, 2007, 07:42 AM
#2
Thread Starter
Member
Re: CR11 issue...please verify for deployment purposes....
someone provide some help .....
-
Mar 23rd, 2007, 07:44 AM
#3
Re: CR11 issue...please verify for deployment purposes....
what you used?
a) Crystal report viewer
b)crystal report control
-
Mar 23rd, 2007, 08:39 AM
#4
Frenzied Member
Re: CR11 issue...please verify for deployment purposes....
What will you be using as an installation and setup package?
Most packages will read your project file, and, if not include by default, at least display for your selection, everything in terms of dependency files that your project requires to run on another machine.
Do you have a test machine available that you can run your package on before deploying it?
Beantown Boy
Please use [highlight=vb]your code goes in here[/highlight] tags when posting code.
When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.
-
Mar 23rd, 2007, 01:38 PM
#5
Thread Starter
Member
Re: CR11 issue...please verify for deployment purposes....
Mr. SeanK..I am using the SETUP FACORY 7 install builder
And Shakti....I am using the following...
-->References window:
1. Crystal ActivX Report Viewer Library 11.0
2. Crystal Reports ActivX Designer Design and Runtime Library 11.0
3. Crystal Reports ActivX Designer Runtime Library 11.0
-->Components -> Controls window:
1. Crystal ActivX Report Viewer Library 11.0
so both u guys .... finish what u were saying...
-
Mar 23rd, 2007, 04:13 PM
#6
Re: CR11 issue...please verify for deployment purposes....
All you need to deploy for CR to work is the merge modules. You will need to remove all other dll/ocx from your project that are CR's
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|