10 Apr 2008 @ 3:51 PM 

Preview of the Tutorial

Your computer must have the following softwares installed:

1. MS Visual Basic 6.0 (Updated with SP6 recommended)

2. Seagate Crystal Reports 8.5 Developer Edition

3. MS Access 97, 2000 or 2003 (From MS Office 2000/XP/2003 suite)

4. Adobe Reader (to open the Tutorial.pdf)

Recommendation:

Please use Microsoft ActiveX Data Control 2.5 or higher (I use MDAC 2.8)

Please note that this tutorial is not applied for prior version of Visual Basic (4/5) or VB.Net, other Crystal Reports products like Crystal Decision/Enterprise/Professional/Crystal Report 9 or later or MS Access 2005 or later. If you have any question on how to use it with other type of database system like MS SQL Server 2000, please post it here. I shall try to help. Currently I have just started to learn to use MySQL and will look at VB.Net when I am free.

In this tutorial, I am using MS Access 2000 format with password set to it. It is recommended to set the database password with length more than 20 character. I use is ADO method to connect to the database. If you prefer DAO, please tell me.

I assume you have some basic programming skills in Visual Basic 6. I am trying to make my tutorial as simple as I could. Please ask if you have any problem understanding the code.

For the method of embedding Crystal Reports to Visual Basic 6, the method explained in the tutorial is the easiest one in my opinion. I am using a CRViewer component to load external *.RPT file which I think is better than using the Crystal Reports ActiveX control (OCX ) method. There is another method by using Report Designer Component (RDC) where the report design is embedded into the project. Perhaps it is good way to protect your report design but this will create VB temporary files (*.TMP) in your C:\ path and you need to recompile the exe if you want to change the report design.

I think many programmers are looking for the method to load dynamic image in the report. Before I found this solution, I have tried many methods including load static pictures and some code only allow me to load bitmap files. Another method is by loading OLE data from the database which I try to avoid because I don’t want my database file to grow bigger. MS Access file has a limitation to store a file size more than 2GB where I learn from other forum or articles. So in this tutorial, it only load the path to the image file from a database table and update the picture in the report. A visitor who downloaded my tutorial has asked me whether he can load a BLOB data from the database. I have a solution for him and it also support PNG file whereas the project in my tutorial only able to load BMP, JPG and GIF files.

Tutorial File: PDF ZIP
VB6 Project: Source Code

Related post:
Crystal Reports Tutorial Update
Load Dynamic Image in Crystal Reports 10 using Visual Basic 6

Posted By: Aeric
Last Edit: 23 Feb 2010 @ 08:51 PM

EmailPermalink
Tags


 

Responses to this post » (3 Total)

 
  1. Aeric says:

    Please vote for me in Planet Source Code submission at
    http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=70000&lngWId=1
    if you find this tutorial is useful.

    Thanks.
    Aeric

  2. marvin hernandez says:

    http://aeric.poon.my/?p=12

    can u reupload your tutorial found in the link above because its already inactive..titled “Load Images in Crystal Reports dynamically with Access 2000” posted “10 Apr 2008 @ 3:51 PM”

    i’m doing a project right now..an organization record system. i’m using vb6 and 9.0 and i was having a bad time figuring out how to put a dynamic image on my report.
    i’m trying to migrate to crystal report xi..

    hope you could help me and hear from you soon.

  3. Aeric says:

    Hi marvin,
    I have fixed the broken links and reupload the files.

    If you still unable to download the files, you can visit my submission in pscode at Tutorial on How to Load images in Crystal Reports dynamically Using Visual Basic 6 and Access 2000

    Please also check the following blog post. It might help for migrating your project to Crystal Reports 10 or MS SQL Server 2000.
    Load Dynamic Image in Crystal Reports 10 using Visual Basic 6

Post a Comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


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