Aeric Poon

Preview:

Visual Basic 6 and Crystal Reports 10 reference

I received emails from a person call Paul. He told me that he is unable to open my project using Crystal Reports 10 so I decided to modified my previous project to load images in Crystal Reports 10 using Visual Basic 6 connected to MS Access 2000 and MS SQL Server 2000.

Updated 28 Nov 2009:
Common Mistake
If you have followed my Tutorial (page 19-29), you may find out that I have renamed the objects in the report using VB6. Unfortunately I may have created a confusion by renaming the default Fieldx to adoFileName. Some readers may interpret it as ado.FileName and hence replacing the code with the following line.
If .Item("ado.FileName").Value <> "" Then
Set bmp = LoadPicture(App.Path & "\Cake\" & .Item("ado.FileName").Value)
Set .Item("picCake").FormattedPicture = bmp
Else
Set .Item("picCake").FormattedPicture = LoadPicture("")
End If
Please do not follow the name when you hover the mouse pointer on the report design! Use the name shown in the VB IDE properties window.

i.e:
Wrong: .Item(“ado.FileName”).Value
Correct: .Item(“FileName”).Value

Related posts:
Load Images in Crystal Reports dynamically with Access 2000
Crystal Reports Tutorial Update

Download: Source Code (505KB)

The zip file contains MS Access 2000, MS SQL 2000 database backup, Crystal Report file, VB6 source code and some images.

Keywords: Visual Basic 6.0, VB6, ActiveX Data Object Control, ADO 2.8, Access 2000, SQL Server, password, print, Crystal Reports, 10.2, 10.5, CRAXDRT, CRAXDDRT, section, dynamic, images, load

Preview

Beta version (21.0MB): Download Now

Features:

- Select Company

- Backup Database

- General Journal

- View Chart of Account

- View Chart of Template

- Maintain Template Group, Template, Menu

- Maintain Type, Head, Account, Ledger

- Master Lists Report

- General Journal List Report

- Trial Balance Report

- Balance Sheet Report

- Ledger Report