在Crystal Report中显示图像/ BLOB数据 [英] Displaying images / BLOB data in Crystal Report
问题描述
嗨伙计们,
在我们的数据库应用程序中,我们有许多工作人员,每个人都将照片保存为服务器上的jpg文件。
我们已经开发了一份报告,其中包含有关每个人的信息,并希望在页面上显示相关照片以及该人的信息。
我正在使用Crystal Reports在Visual Studio 2008(VB)应用程序中创建报表。
后台数据库是在Windows环境中运行的MySQL数据库。
我已将照片导入特定的表格,作为BLOB数据。
在Crystal Report的设计模式中,我可以看到报告中第一个人的图片,但是当我预览报告时,照片不会显示 - 只有相关领域的边界。
任何人都可以建议我如何在报告的每一页上显示不同的图像。
在此先感谢,
Jerry。
Hi folks,
Within our database application we have a number of staff, each of whom has a photo saved as a jpg file on the server.
We have developed a report with information about each person and would like to have the relevant photo displayed on the page with the person''s info.
I am using Crystal Reports to create the report in a Visual Studio 2008 (VB) application.
The background database is a MySQL database running in a Windows environment.
I have imported the photos into a specific table for the purpose as BLOB data.
In the design mode of the Crystal Report I can see the picture for the first person on the report but when I preview the report the photo is not displayed - only the border of the relevant field.
Can anyone advise how I may achieve the display of a different image on each page of the report.
Thanks in advance,
Jerry.
推荐答案
用于图形在报表中控制,您将拥有一个可以采用文件路径的属性。将其设置为具有jpg文件名的字段。应该这样做,我想。
For the graphic control in your report, you will have a property that can take a file path. Set that to the field that has the jpg file name. That should do it, I think.
嗨伙计们,
只是典型的 - 刚刚发布了一个帮助请求而不是我得到的它工作。一切都很好。问题是将BLOB信息导入表格。
干杯,
杰里。
Hi folks,
Just typical - no sooner posted a help request than I get it working. All fine now. Issue was with importing the BLOB info to the table.
Cheers,
Jerry.
这篇关于在Crystal Report中显示图像/ BLOB数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!