CODEWITHSUNDEEP
crystal-reports
Yuvi
Yuvi

Reputation: 1

crystal report Image or QR Code not appear

need to show Qr Code from database in crystal report

image code are stored in sql table

apart from the image other fields are displayed

screenshot; missing image icon

Upvotes: 0

Views: 1902

Answers (3)

jbertrand
jbertrand

Reputation: 148

It's easiest to use an online service like the Google API.

In Crystal Reports you can :

  1. Insert a picture
  2. Edit the conditional formula associated with the picture's Graphic Location property
  3. Provide a link that will generate the QR code. For example: "http://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=" + {table.field1} + "," + {table.field2}

Upvotes: 1

MilletSoftware
MilletSoftware

Reputation: 4001

If the binary column stores the image as one of the typical formats supported by Crystal, you can simply drag that column onto the Crystal report design canvas and it will be displayed in preview.

I believe the supported image types include JPG, BMP, TIF, and PNG. If the image format is not one those, you would need to convert.

Upvotes: 0

MilletSoftware
MilletSoftware

Reputation: 4001

Please Google Crystal Reports and QR Code. There are many options.

Also, it's not clear what "image code are stored in sql table" means.

Upvotes: 0

Related Questions