rdlc image source from database didn't show up

[Edwin Kurniawan]

I'm using essential studio ver 14.4.0.15 and i'm having a rough time to show image from database in a rdlc report
Image was retrieve from database as byte[] and in rdlc report designer, the image's source is already set to database, value has been set to corresponding field, mimetype is set to image/png

When i preview the report, the image url is showing [400] bad request
(e.g.: "/api/ReportApi/GetResource/?key=2327C707-BFBD-DB37-BC99-70A616AA88FA^viewer_Signature_f8456b12-2e13-498b-8e02-0009f414e8b4&resourcetype=sfimg&isPrint=null").
Because the [isPrint] parameter has null value, i tried to change the value to false with developer tool, not getting [400] bad request anymore, but it showing white blank image instead

Working fine when i'm using an image as embedded resource (but it can't solve my prob)

Please help.


Best regard,


Edwin

[Edwin Kurniawan]

Other sample that showing image from database on rdlc ejreportviewer that i've downloaded was using syncfusion ver 13.xx which are working fine.
Can't really figure out what is wrong other than miscode in the dll ver 14.4.0.15

[Yuvaraj Devarajan]

Hi Edwin, 

Thanks for contacting Syncfusion support.  

We were unable to reproduce the mentioned issue at our end. We have checked the report RDLC file by loading the image from dataset with 14.4.0.15 build assembly version and it working properly at our end. The mentioned issue might occurred when the image source is specified as embedded image in property window while passing the image value from datasource. So we request you to ensure that the image source, Field value and MIME type are specified correctly in image property when passing the image value from datasource field as shown in below screenshot, 

 

For your reference, we have prepared a sample and it can be downloaded from,  

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/ReportSample376363496.zip 

If the issue still persists, then share the issue reproducible RDLC file and image byte value to validate the mentioned issue at our end. 

Regards,  

Yuvaraj D.   

[Edwin Kurniawan]

I figure it out, my datasource's image datatype is byte[],
but in the sample, the datasource's image data type is string.

I have tried to convert from byte[] to base64 string -> Convert.ToBase64String(byte[] ...) before too,
but in the rdlc image field value, i converted it back base on this stackoverflow answer

=System.Convert.FromBase64String(Parameters!<sparamname>.Value)and it didn't work.

Then i look again at your sample, it appear that there was no need to do convert back from the base64string for the rdlc image field value and finally got it works

I can't find any information about this before though.

Thanks Yuvaraj Devarajan.

Oh and one more issue that i've found, some image are having isPrint=null property in the image src.
Apparently, only happened to image with parent tablix inside tablix


Best Regard,

Edwin.

[Yuvaraj Devarajan]

Hi Edwin, 

We were unable to reproduce the mentioned issue at our end. We have tested the Report by placing the image report item inside the Tablix report item and in image URL “isPrint” value is rendered as false as in below screenshot.  

 

For your reference, we have prepared a sample and it can be downloaded from, 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/ReportDemo-2029237169.zip  

If the issue still persists, then revert the sample with issue reproducible procedure to validate the mentioned issue at our end. 

Regards, 

Yuvaraj D.