Tutorial on How to Load images in Crystal Reports dynamically Using Visual Basic 6 and Access 2000
Using Visual Basic 6 and Access 2000. By Aeric Poon. Introduction. This tutorial will show you how to create a Visual Basic 6 project which will generate a …
More PDF Content
Tutorial on How to Load images in Crystal Reports dynamically Using Visual Basic 6 and Access 2000
Page 1
Tutorial on How to Load images in Crystal Reports dynamically Using Visual Basic 6 and Access 2000 By Aeric Poon Introduction This tutorial will show you how to create a Visual Basic 6 project which will generate a report using Seagate Crystal Reports 8.5 Developer Edition. You will save the path of the image files in a MS Access database where it is protected by password. This project will use an external Crystal Report file and will be previewed using Crystal Viewer control. Get Ready In this tutorial, I will use some small images I get from forwarded email. I created a folder name Tutorial where all the files will be store inside this folder. I also created some images with different type like bmp, jpg, gif, png and tif which will be stored inside a folder name Cake. Contents Step 1 Create a Database file using MS Access Step 2 Create a Crystal Reports file Step 3 Create a Visual Basic Project Step 1 Create a Database file using MS Access Run MS Access to create a blank database. Create a folder name Data. In the File New Database dialogue box, type the name dbCake (dbCake.mdb) and click on Create to save this file inside folder Data. You have now created a database file.
Page 2
Click on Create table in Design view. Click the Design button to create a new table. Create the following fields in the new table: CakeID (Text), CakeName (Text), FileName (Text) Set focus at CakeID and then click the Primary Key button to make this field as Primary Key.
Page 3
Close the Table window or click Save button. Save this table name as Cake. Right click and Open table Cake.
Page 4
Insert some records in the table Cake. Save and Close the table Cake. Set a Database Password. For this tutorial, I set the password as yuMMy20.
Page 5
Click OK and Close this file. Now you have a database file ready. Step 2 Create a Crystal Reports file Run Crystal Reports 8.5 Developer. Click on As a Blank Report radio button in the Crystal Report Gallery dialogue box and click OK.
Page 6
You will see a Data Explorer dialogue box. Click on the plus sign of More Data Sources. Click on the plus sign of Active Data and then click on Active Data (ADO).
Page 7
You will see a Select Data Source dialogue box. Choose MS Access Database from the dropdown list and click OK. Browse for the Data folder where we store the database file, click dbCake.mdb and then click OK.
Page 8
A Login dialogue will pop out. Enter yuMMy20 for the password and click OK.
Crystal Reports for Visual Basic User's Manual... - Microsoft Corporation
Crystal Reports for Visual Basic User's Manual :... - Microsoft Corporation
Crystal Reports for Visual Basic User's Manual :... - Microsoft Corporation
No Stress Tech Guide To Crystal Reports Basic For... - Tolana Publishing
