07 Nov 2009 @ 2:25 AM 

Preview:

CR10

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

Posted By: Aeric
Last Edit: 28 Nov 2009 @ 02:04 AM

EmailPermalinkComments (7)
Tags

 Last 50 Posts
 Back
Change Theme...
  • Users » 2
  • Posts/Pages » 129
  • Comments » 197
Change Theme...
  • VoidVoid « Default
  • LifeLife
  • EarthEarth
  • WindWind
  • WaterWater
  • FireFire
  • LightLight