I created a basic table report (SSRS report) to be integrated with the Model-driven App. As per user requirement, I need to have a QR code in my SSRS report but I cannot find any way to achieve it. Hence, my question is "How to generate a QR Code in the SSRS report for a Model-driven App?" The guidance on how to accomplish this would be highly appreciated.

Hi @Yue Zhen Khor As Olaf said, SSRS does not have the functionality to generate QR codes. You can refer to this blog to see if it is reliable: https://www.sqlservercentral.com/articles/generate-qr-code-barcodes-in-an-ssrs-report-with-the-qrcoder-library . You can also refer to the discussion in this thread: https://stackoverflow.com/questions/36811438/how-do-i-show-a-qr-code-in-ssrs . If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know. Best regards, Aniya

There is no build-in control for QR Code in SSRS available, you have to search for a 3rd-party solution.

How to generate a QR Code in basic table report SSRS reprt using the Report Server Project

Accepted answer

AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor

2023-11-07T01:11:56.6366667+00:00

Hi @Yue Zhen Khor

As Olaf said, SSRS does not have the functionality to generate QR codes.

You can refer to this blog to see if it is reliable: https://www.sqlservercentral.com/articles/generate-qr-code-barcodes-in-an-ssrs-report-with-the-qrcoder-library.

You can also refer to the discussion in this thread: https://stackoverflow.com/questions/36811438/how-do-i-show-a-qr-code-in-ssrs.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya
Please sign in to rate this answer.
Yue Zhen Khor 20 Reputation points

2023-11-07T08:25:17.9166667+00:00

I manage to generate the qr code using the blog you provided. But I hit error when I want to upload the rdl to model-driven app. May I know how to resolved the error?

Yue Zhen Khor 20 Reputation points

2023-11-07T08:25:48.1666667+00:00

The error is as follow:

System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: The report server has RDLSandboxing enabled and the report contains custom code. Remove the Code element from the report definition. (Fault Detail is equal to Exception details:

ErrorCode: 0x80048293

Message: The report server has RDLSandboxing enabled and the report contains custom code. Remove the Code element from the report definition.

TimeStamp: 2023-11-07T08:17:54.4824743Z

--

).

AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor

2023-11-07T08:41:40.8466667+00:00

Hi @Yue Zhen Khor

When RDL Sandboxing is enabled, the following features are disabled:

Custom code in the <Code> element of a report definition.

RDL backward compatibility mode for SQL Server 2005 Reporting Services (SSRS) custom report items.

Named parameters in expressions.

For more details, you can refer to this document: Enable and disable RDL sandboxing for Reporting Services in SharePoint integrated mode.

Best regards,

Aniya

Yue Zhen Khor 20 Reputation points

2023-11-07T14:05:39.44+00:00

May I know is there any ways to overcome this restriction so I can use the 3rd party solution that you provided to generate qr code in SSRS report and upload it to Model-driven app?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to generate a QR Code in basic table report SSRS reprt using the Report Server Project

1 additional answer

Your answer