crsytal crashes

[strelok31]

I have this really weird issue going on. I am using an old version of Crystal Reports. The version that I am using is 4.6.1.0. I am using VB 6 and SQL Server Express.

I have created several reports that use several database fields. Evertyhing is working fine. I have created another report that uses some database fields. The new report also uses one database field (firm name) that I use in the other reports as well but for some reason the new report crashes when I use this field. I have removed this field (firm name) from the new report and it works fine, but when I add this database field it crashes for some reason. I can't figure out why the new report crashes, while the old one which uses the same field works fine.

Here is the code that I use.

Dim report2 As CrystalReport
report2.Connect = "DSN=SQL Server Remote Location;UID=ikim;PWD=red;DBQ=<CRWDC>Database=CopyRequest"
report2.ReportFileName = sPrintLocation & "\printing2.rpt"
report2.SelectionFormula = "{CopyRecords.unique_id} =" & scurrenlyOpenRecord

report2.PrintReport

[strelok31]

Any ideas? I don't understand why the same database field works on 1 report and does not on the other one?

[strelok31]

i already figured it out. In this version of crystal reports i can only use certain number of character fields from the database. If I exceed that number crystal crashes.