How to display pictures dynamically

[khalidone]

Hi how are you?

I want to display the pictures of employees on the basis of links I have stored in the database for each employee. I am using ms access database and I have stored the links of each pic with respect to employee. I am not using OLE object because it makes my database file heavy. I am using crystal report 9.0.

Please help me in this regard. I will be very greatful to you

Thanks

Khalid

[K.Babu]

Originally posted by khalidone
Hi how are you?

I want to display the pictures of employees on the basis of links I have stored in the database for each employee. I am using ms access database and I have stored the links of each pic with respect to employee. I am not using OLE object because it makes my database file heavy. I am using crystal report 9.0.

Please help me in this regard. I will be very greatful to you

Thanks

Khalid

Hi,

Refer the following link bellow.

http://www.codeguru.com/forum/showth...&pagenumber=32

Subject at :
View Pictures from database.Table.field contains picture filename with path.

[khalidone]

Thanks alot K Babu. You have solved my problem. Your code really works

Thanks

Khalid

[K.Babu]

Originally posted by khalidone
Thanks alot K Babu. You have solved my problem. Your code really works

Thanks

Khalid

Rate this thread.

[bestleader]

Hi K.Babu,

I have got this trouble in the ASP.Net. Have you got any solutions for ASP.Net?? Please help me in urgent.
Thank you in advanced for any suggestion.

[nadeemsharifuddin]

Dear Mr. K Babu,
Can you please help me.
I am currently using Visual Basic 6. SQL Server 2000 and Crystal Report 10 to show reports.

Is there a way to Show pictures dynamicaly in Crystal report from File Patch mentioned in table field. (with out adding image in SQL servier 2000 fields)
The images are in a folder (C:/images/Picture1.bmp)

I want to show this picture in crystal report against picture1 in database field.

Please advise how can show specific record picture in crystal report , showing picture from Folder.

Nadeem.
Sialkot Pakistan.

[nadeemsharifuddin]

Hi,

Refer the following link bellow.

http://www.codeguru.com/forum/showth...&pagenumber=32

Subject at :
View Pictures from database.Table.field contains picture filename with path.

Dear K.Babu,
I have same problem. I have downloaded your CRPhoto zip file but your project is not opening in Visual Basic 6.

Please advise me how can I use your code in Visual Basic 6 to run Crystal report for viewing pictures, where as picture path saved in database.

Please it is important.

[nadeemsharifuddin]

Dear Sir,
Please advise me how to show pictures saved in a folder and folder paths are given in database fields only.

I wanted to show those pictures in crystal report 10 while using Visual Basic 6 code.

I want that crystal report show pictures from folders as per picture number mentioned in picture database table and per its folder path.

Please advise, I have tried. CRPhoto.zip but it is not opening.

[K.Babu]

Hi,

What problem you have faced in CRPhoto.zip file.

yours friendly,
K.Babu

Dear Sir,
Please advise me how to show pictures saved in a folder and folder paths are given in database fields only.

I wanted to show those pictures in crystal report 10 while using Visual Basic 6 code.

I want that crystal report show pictures from folders as per picture number mentioned in picture database table and per its folder path.

Please advise, I have tried. CRPhoto.zip but it is not opening.

[michelleong]

hello there! is there a way to add .jpg images instead of .bmp?

[Aeric]

I want to know too. And is there any way i can hide the picture filename below the picture?

[shiburaj]

I am using this code,
Private Sub cmdPrint_Click()
Dim i As Integer
Dim intRow As Integer
fraSelect.Visible = False
Set Report = Appl.OpenReport(App.Path & "\report1.rpt", 1)
Set Oparam = Report.ParameterFields
Report.PrinterSetup Me.hWnd
For intRow = 1 To fgShow.Rows - 1
If fgShow.TextMatrix(intRow, 3) = -1 Then
Text1.Text = fgShow.TextMatrix(intRow, 0)
Oparam.Item(1).AddCurrentValue (Text1.Text)

With CRViewer1
.ReportSource = Report
.ViewReport
.Zoom 100
Set CrSecPH = Report.Sections(3)
For i = 1 To CrSecPH.ReportObjects.Count
If CrSecPH.ReportObjects(i).Kind = crOleObject Then
Set Pic1 = CrSecPH.ReportObjects(i)
' Call CrSecPH_Format(CrSecPH.ReportObjects(i))
End If
Next i
Set CrSecPH = Nothing
.PrintReport
End With
End If
Next intRow
Set Oparam = Nothing
Set Report = Nothing
End Sub

Private Sub CrSecPH_Format(ByVal pFormattingInfo As Object)
Set Pic1.FormattedPicture = LoadPicture("\\server\Application\Photos\" & UCase(Trim(Text1.Text)) & ".JPG")
End Sub

But the problem is that, the image is getting loaded after the print.