Skip to Content
0
Former Member
May 09, 2011 at 06:48 AM

Image from Database

17 Views

I have a Table with ReportElements. Every Element have a ID (ReportElementID) and a String (reportElementValue) or a Image (ReportElementBLOB).

To show the String in my report I use a SQL-Formular: "sqlCompanyName" - "(SELECT ReportElements.ReportElementValue FROM ReportElements WHERE ReportElementID='CompanyName')". That works fine.

If a want to show a logo on my report (ReportElementID='CompanyLogo') I try to use "sqlCompanyLogo" - "(SELECT ReportElements.ReportElementBLOB FROM ReportElements WHERE ReportElementID='CompanyLogo')"

I can put the field to my report. On the report I can see the logo. But if I change to the preview of the report, that CR2008 crashes.

My Database is a MS-SQL 2008 Express - ReportElementBLOB is from Type "Image" - I using CR2008