PDA

Click to See Complete Forum and Search --> : [RESOLVED] Absolutely new to Crsytal Reports 11 and its use in VB6....


intellogo
Mar 3rd, 2007, 12:57 PM
Hi,;)

I have just downloaded and installed the Crystal Report 11 Dev Ed product. On the other hand, I have developed a project with VB 6 & MS ACCESS 2000 (as the database with password protection). The only thing remaining is to create a couple of reports for my project.
After installing & getting the CR11 to be integrated into Visual Studio 6, I have selected the folowing items in the VB6 IDE
These are:

-->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

-->Components -> Designer window:
1. Crystal Reports 11


I have also tried the built-in wizard (from within CR11) that automates the process of report creation. But this automated process is ok for situations where no specific criteria is required to query records from the database, and instead just to simply list all the avialable records of a table.


QUESTION:
---------
1. Do I use the same database connectivity code from the VB6 IDE's
code view (that was used for my project) to connect & create
reports in CR11 ?

2. Should the report be designed from:
(a) within CR11 OR....
(b) from the Project Explorer in VB6 IDE and
selecting to add the Crystal Reports module OR....
(c) purely from VB6 code ?

3. How do I provide specific deciding parameteres, upon which
records would be queried ?

Any assistance & help would be gr8tly appreciated....:cool:
----
Regards,
Intellogo

AIS4U
Mar 3rd, 2007, 03:19 PM
Have you seen this link about using Crystal Reports with Visual Basic 6.0?


http://support.microsoft.com/kb/193336

Hack
Mar 4th, 2007, 06:21 AM
Moved to reporting

AIS4U
Mar 4th, 2007, 04:56 PM
No more PM's please.

I don't know Crystal Reports and I don't want to know Crystal reports.

You asked this question on Feb. 16, 2007 and now again.

Apparently no one is able to provide the information that you need. I have posted several links below, if they don't help then I guess you will have to go buy a book.
http://www.shiningstar.net/tutorials/crystalreports/crystalreportstutorial.htm

http://www.hotcoding.com/Programming/vb/200611/35391.html

http://www.crystalkeen.com/articles/

http://www.123aspx.com/redir.aspx?res=30160

http://www.tutoronline.co.uk/crystalreports.html

shakti5385
Mar 5th, 2007, 02:56 AM
1. Do I use the same database connectivity code from the VB6 IDE's
code view (that was used for my project) to connect & create
reports in CR11 ?
yes
2. Should the report be designed from:
(a) within CR11 OR....
(b) from the Project Explorer in VB6 IDE and
selecting to add the Crystal Reports module OR....
(c) purely from VB6 code ?

all are possible but in the project you need to use the crystal report viewer
And out side the project if you are making the report then use the crystal report control.


3. How do I provide specific deciding parameteres, upon which
records would be queried ?

use parameter, selection formula, sql query

I suggest you that just read the crystal report tutorial at my signature.

intellogo
Mar 6th, 2007, 08:40 AM
Hey Shakti,

If I want to create the report in such a way such that, the reports will be generated on the end-user's PC eventhough that PC does not have CR11 installed, then do i have to design my reports in the CR11 Report Designer interface itself....OR....should i use the CR11 module by right-clicking the Project Explorer in VB6 for designing the reports ??

which one...is more recommended by u ???

And when will u come online..i have some real doubts to ask...

--
Regards,
Gautam Naidu
intellogo@gmail.com