How to pass Database value to LoadPicture in Crystal report

Question

Hi

How to pass Database value to LoadPicture in Crystal report. I want thos value "\C_150425001.bmp" to be from Database field

Private Sub Section5_Format(ByVal pFormattingInfo As Object)
    Set Picture1.FormattedPicture = LoadPicture(App.Path & "\C_150425001.bmp")
End Sub

Thanks

Emily Foster · Answer

Hello! I see you're looking to dynamically pass a database value to LoadPicture in Crystal Reports. This can be achieved by fetching the image file path from a database field and then setting the FormattedPicture property accordingly. Here's a high-level overview of how you can accomplish this: 1. Retrieve the image file path from the database field in your Crystal Reports application. 2. Set the FormattedPicture property of your Picture control to load the image from the obtained file path. In your code snippet, you can modify it to dynamically load the image based on a database field value. Here's an example of how you can achieve this: Private Sub Section5_Format(ByVal pFormattingInfo As Object) Dim imagePath As String ' Assuming you have a field named "ImagePath" in your database containing the file path imagePath = YourRecordset.Fields("ImagePath").Value If Not IsNull(imagePath) Then Set Picture1.FormattedPicture = LoadPicture(App.Path & "\" & imagePath) End If End Sub In this code snippet: - `YourRecordset` refers to your database recordset where you retrieve the image path. - `ImagePath` is the field in your database table that stores the image file path. - Ensure proper error handling and validation for cases where the imagePath may be null or invalid. By implementing this approach, you can dynamically load images in your Crystal Report based on values retrieved from a database field. If you have any specific database connection or retrieval questions, feel free to ask for more detailed guidance!