About Crystal Report & VB6.

[solar115]

I plan to develop a program by VB6 and create the report by Crystal Report. I want to create it by use some database files. One is use MySQL and One is use Access. I think about that some problem maybe occur (or not) when I use it by call from VB. Please tell me.

- On Access case, Crystal report will be fixed the directory of Database or it can be change on VB code when use it?

- On MySQL case, Can I send DatabaseName, ServerName, Username and Password by VB that Crystal Report maybe use it?

Maybe this look as stupid question but I really want to know.

[SkiNLaB]

Hi, i am also using VB with access and MySQL

check out www.vbmysql.com for the article about using Crystal reports with MySQL, i'm sure it will answer almost all ur questions!

[solar115]

Thank SkiNLaB,
Now I visit to vbmysql.com and look for some solution that can be solve my problem. I'm not found the solution that really match my problem. However I will try continue look for. If anybody have some suggestion about my problem please tell me.

[SkiNLaB]

http://www.vbmysql.com/articles/crystalvbmysql.html

[solar115]

Thank you very much SkiNLaB,
Thank you that you follow to look at my problem. I have been visit the link that you tell me. In first time this code make me confuse that cause it's say about Version9.1 but I use lower. The style of logic that this code use maybe difference from my style that make me think it cannot solve my problem.

However after you tell me in second reply to look at this code (first time you said only about this website) it make me think that maybe it can help me cause you suggest me(I think you are a good guy and you will suggest me a good idea :D). So I will come back to see it again.

About Version problem, I think I can use the lower version cause that it has a same Component and DLL. Only the version that may difference.

'THIS CODE IS USED TO DISPLAY A CRYSTAL REPORTS 9 REPORT USING
'DATA PULLED FROM A MYSQL DATABASE USING ADO AND VISUAL BASIC 6
'YOU NEED REFERENCES TO: Microsoft ActiveX Data Objects 2.7 Library
' Crystal Reports 9 ActiveX Designer Run Time Library
'YOU NEED THE COMPONENT: Crystal Reports Viewer Control 9
'ADD THE CRVIEWER91 COMPONENT TO YOUR FORM AND NAME IT CRViewer.

So I think now it a time to change my style to this way first. May I will use a little time to understand this code. However, For some problem I will ask you again (:D)

[solar115]

Oh, I think I forgot something.

I focus it in to MySQL already but for Access is a question that I forget to find the answer. :eek:

[solar115]

Hey SkiNLaB,
Could I ask you something more? I see the code and it will bound to RecordSet (rs). Is it mean all data that be shown in the report will be came from this rs only right? How can I do if my report may be use more than one table or more than RecordSet?

[SkiNLaB]

u can have multiple tables in the one recordset, but only one recordset in the report.