Jan 26, 2006 Need help for crystal report 9 and vb6. Replies (2) Email updates. Dim path As String Dim oReport As New CRAXDDRT.Report Dim crApp As New CRAXDDRT.Application. For the second time. The fix for this is to install the Crystal Reports 9 Service Pack 6: Download the SP6 for Crystal Reports 9 Here. It worked for me. Best Regards, The Chad.
My application is a vb application and I am using Crystal report 8.5. It is working fine on 32 bit system and 64 bit system of Windows 2003 server. When I run the same application either on win7 64 bit or on 2008 64 bit, report does not open. I am using vb script to access the database. Free driver for windows 7. I don't know if this will be helpful to you at all.I'm not a developer, but I do everything else here. I recently (and finally) got CR 8.5 to work on our workstations on the 64-bit version of Windows 7.
I set up the workstations for the employees, so I just copy certain CR files and register a couple DLLs to make CR work. Our internal applications are developed using Delphi, and use CR 8.5. It seems to be a little quirky. The CR DLLs that we need to register in Windows have to be registered using both the 32- and 64-bit versions of regsvr32.exe. The same goes with the MSSLQ ODBC connection.it needs to be set up on both the 32- and 64-bit versions of odbcad32.exe. I was only doing this with the 64-bit versions at first, but a couple of our applications choked until I also did it in the 32-bit version (the others worked fine). Plus, all of the CR files need to go to the SysWOW64 folder instead of system32 for our applications to work correctly.
Have a look at the SQL Server Profiler tool which is part of the Management Tools. It will show you all the transactions happening on your database. Add the filters so just for your user / application run the report normally from your application and you will see the SQL being executed on the Server. From what is running it should give you an indication of what data is being grabbed from which tables.
It takes a bit of experimentation to get the filters working properly to see the data you want and then you still have to be able to understand the SQL but I've always found it a good place to start when I haven't a clue where the data is coming from. Once you know where the data is, you have several way's of presenting it; Crystal Reports, MS Report Builder (and server), Excel data connections etc. I don't know if this will be helpful to you at all.I'm not a developer, but I do everything else here.
I recently (and finally) got CR 8.5 to work on our workstations on the 64-bit version of Windows 7. I set up the workstations for the employees, so I just copy certain CR files and register a couple DLLs to make CR work. Our internal applications are developed using Delphi, and use CR 8.5. It seems to be a little quirky. The CR DLLs that we need to register in Windows have to be registered using both the 32- and 64-bit versions of regsvr32.exe. The same goes with the MSSLQ ODBC connection.it needs to be set up on both the 32- and 64-bit versions of odbcad32.exe. I was only doing this with the 64-bit versions at first, but a couple of our applications choked until I also did it in the 32-bit version (the others worked fine).