Printable View
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,Quote:
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
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.
Thanks alot K Babu. You have solved my problem. Your code really works
Thanks
Khalid
Rate this thread.Quote:
Originally posted by khalidone
Thanks alot K Babu. You have solved my problem. Your code really works
Thanks
Khalid
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.
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.
Dear K.Babu,Quote:
Originally Posted by 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.
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.
Hi,
What problem you have faced in CRPhoto.zip file.
yours friendly,
K.Babu
Quote:
Originally Posted by nadeemsharifuddin
hello there! is there a way to add .jpg images instead of .bmp?
I want to know too. And is there any way i can hide the picture filename below the picture?
:wave:
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.