After using Lookupset in SSRS report getting error while open report in CRM

(1) Share

Report

Posted on by Tejas9474

Is it possible to use Lookupset function in reports for CRM Version 1710 (9.1.0.11733) online.
I keep getting an error "This report can’t upload because there are restrictions with SQL Server Reporting Services reports when Report Definition Language (RDL) Sandboxing is enabled." Please find error snapshot.

5282.error.PNG

I am using VS2015 and the following expression(syntax).

=Join (LookupSet(Source_dataset_field,Destination_dataset_field, Result_Field ,"Dataset_name"), "," & vbCrlf)

If I remove these expressions report working fine.

I have tried with change target server version of project property in visual studio and pick RDL file from bin/debug folder. but, Its not working.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

Hello,

That's weird. Here is the list of disallowed members - docs.microsoft.com/.../rdl-sandboxing that can cause mentioned error.

You have 3 of those - Join, LookupSet and vbCrlf. Can you please use every of mentioned members in formula to find the "guilty" one? My assumption that it should be vbCrlf but I want to confirm.

Once you know which of member causes an issue you can either find a workaround or get in touch with Microsoft for clarification.

Was this reply helpful? Yes No
Tejas9474 on at

Like (1)

Report

Thanks Andrew,

& vbCrlf was causing problem. for crm, we need to use & vbCRLF instead of & vbCrlf.

Was this reply helpful? Yes No