Masukkan Field gambar dari tabel SQL Server ke Crystal Report.
Lalu lakukan Query seperti contoh dibawah ini:
Option Explicit
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim rpt As New CrystalReport1
If rs.State = 1 Then rs.Close
rs.Open "select NamaFieldGambar from namatable", cn, adOpenStatic,
adLockOptimistic
If rs.RecordCount > 0 Then
rpt.DiscardSavedData
rpt.Database.SetDataSource rs
CRViewer1.ReportSource = rpt
CRViewer1.ViewReport
CRViewer1.Zoom 100
End If
From: yogyafree-perjuangan@yahoogroups.com
[mailto:yogyafree-perjuan...@yahoogroups.com] On Behalf Of Bcah Olo
Sent: 05 Juli 2010 10:48
To: yogyafree-perjuangan@yahoogroups.com
Subject: [YF] [TANYA] View Image Crystal Reports
ada yang tau ngak cara nampilin gambar/foto yang tersimpan di database pada
Crystal Reports yang database'y pake SQL 200????
