how to insert a signature into the report

(0) Share

Report

Posted on by Charlie Chen

Hello everybody,

I'm building a report for a single case including info about some details of the case and some info of the user generating the report. Here is the context:

1. A signature of user is capture in the form and stored as an image. The signature is captured by Html5 Canvas, as described in blogs.msdn.microsoft.com/.../capturing-a-signature-in-a-crm-form-using-html5

2. A user wants to generate a report display some details of a case, and the report should be consisted of the user's contact info and the image of signature. I try to design a report template with SSRS, but I don't know how to insert the signature as ana image into the report.

Anyone knows how to do it? Thanks a lot.

*This post is locked for comments

All responses (5)

Answers (0)

Suggested answer

Rudylar 2 on at

Like (0)

Report

how to insert a signature into the report

The answer is in this post : winforms - C# Base64 string can convert to image but not showing in .rdlc Image controls - Stack Overflow

You can confirm similar root cause, by showing the base64 string into a Label. If prefix is similar => same root cause !

If that answers the question, mark as a possible answer.

Cheers,
Charlie Chen 92 on at

Like (0)

Report

RE: how to insert a signature into the report

Hi,

I tried to follow the second link to convert the string to image with System.Convert.FromBase64String. And I managed to up load the report to CRM system. But after I run the report, I could see a blank space in the image area only. Could anyone help?
Charlie Chen 92 on at

Like (0)

Report

RE: how to insert a signature into the report

Hello,

The image is displayed on a webresource and its encoded data is stored into a Multiple Lines of Text type hidden field.

As per your suggestion, I do some works on SSRS as follow:

1.Add an image control to the table.

2. Go to the image properties.

3. click use this field>set expression for value and insert the code " =System.Convert.FromBase64String(Fields!LE_e3de7eccb89c274a9db410a4de8aad02_new_signature.Value)"

4. I ran the query and I got the raw data of the image as follow. It seems that the code doesn't run. And I can't upload the rdl file back to system. A warning pops out.

The log file is:

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: The report server has RDLSandboxing enabled and the Value expression for the image 'Image3' contains a syntax error. Change the expression to use valid RDL expression syntax.Detail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
<ErrorCode>-2147188072</ErrorCode>
<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>The report server has RDLSandboxing enabled and the Value expression for the image 'Image3' contains a syntax error. Change the expression to use valid RDL expression syntax.</Message>
<Timestamp>2016-04-18T17:24:30.9830901Z</Timestamp>
<InnerFault i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>

Please advice what should I do.

Thanks a lot.
Inogic 24,094 on at

Like (1)

Report

RE: how to insert a signature into the report

Hi Charlie,

It is easy to show the image in SSRS if the image is stored as an attachment (Annotation Entity). So if you are storing the image data in CRM then we can use the image control of SSRS to bind the image and show it in the report.

For more insights on showing the image on SSRS please follow this post.

Thanks

Sam
Suggested answer

Alessandro Graps 2,664 on at

Like (0)

Report

RE: how to insert a signature into the report

hi,

if you have the signature as image, you can insert this one in this way:

www.powerobjects.com/.../images-in-your-crm-reports-powerphoto-with-fetchxml-reports

weblogs.asp.net/.../ssrs-report-show-dynamics-crm-note-attachment

jlattimer.blogspot.ch/.../ssrs-report-image-from-crm-note.html

Thanks

A,G,