Crystal Report From VB6

[CurtR]

We have a very simple test Form to try and figure out why we can not call Crystal Reports from VB6. At First it was a missing .ocx that problem appears to have been corrected.

Now we are lost.

There is only 1 Crystal Control, 1-Txt box, 1-Command Button on the Form.
The code is simple:

Private Sub Command1_Click()
Dim Start As String
Start = txtFromdate
CrystalReport1.ReportFileName = "G:\CITECT\Reports\Citect Oracle\Thickner_flows.rpt"
CrystalReport1.ParameterFields(0) = "START;" & Start & ";True"
CrystalReport1.Connect = "PWD = REPORTS"
CrystalReport1.PrintReport
End Sub

The project is published placed on the network, and works fine from machines with VB loaded on them but not from machines without.

The app starts, the Crystal Report flashes on the screen but never actually seems to run.

We are new at this and are to say the least lost!
Can any one point us in a direction to head off in?

Thanks
CurtR

 

[Ruairi]

get yourself a program that will tell you what dll's are in use by a process (HandleEx is a good one for NT and can be freely downloaded somewhere on the web. I cant remember where but i do remember typing handleex.exe into yahoo will return multiple hits. Modules works for Win 95/98 and is available from seagates website.). Then run your VB program on a working machine and bring up the report. Start modules or handleex and see what dlls are in use by your program. Compare this list to the dlls included in you setup program and see whats missing. Crystal dlls have never in my experience been handled reliably by the P&D wizard. Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com