This report can’t upload. This issue can occur when the Report Definition Language (RDL) file is not valid.

(0) Share

Report

Posted on by Community Member

Greetings,

I am using Visual Studio 2015 to build a Sales Order Report and when I try to upload it online I get the error: "This report can’t upload. This issue can occur when the Report Definition Language (RDL) file is not valid." Reading the post I see there are some visual basic limitations however, going through my file I only am using Microsoft.VisualBasic.Interaction.Iif() to show and hide various fields and embedded images in the report.

Any ideas?

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (2)

Community Member on at

Like (0)

Report

Remove this Microsoft.VisualBasic.Interaction from IIF condition and try again

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I removed all the Microsoft.VisualBasic.Interaction from IIF conditions and I get the same error.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am also working in a Sandbox environment if that makes any difference.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I think there are some references still left in the report. I would suggest you to create a bank test report and try to upload it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Created a new report with simple XML from advanced find and got the same results.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

<entity name="salesorder">

<attribute name="customerid" />

<attribute name="totalamount" />

<attribute name="ownerid" />

<attribute name="ordernumber" />

<attribute name="ps_billtocontact" />

<attribute name="createdon" />

<attribute name="statecode" />

<attribute name="salesorderid" />

<order attribute="createdon" descending="false" />

<order attribute="customerid" descending="false" />

<filter type="and">

<condition attribute="statecode" operator="eq" value="0" />

</filter>

<link-entity name="contact" from="contactid" to="ps_billtocontact" visible="false" link-type="outer" alias="a_c7105b6ca935e51180cf00155d286610">

<attribute name="emailaddress1" />

<attribute name="telephone1" />

</link-entity>

</entity>

</fetch>

Was this reply helpful? Yes No
Verified answer

ashlega 34,477 on at

Like (4)

Report

It seems I just ran into this issue.. To resolve, try this:

- Open project properties and configure target version to be 2008...

- Build the project!

- Get that rdl file from the bin/debug subfolder (not from the main folder)

It seems there is a problem with the TargetVersion:

stackoverflow.com/.../can-i-control-the-version-of-new-ssdt-reports-in-visual-studio

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

Thank you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your help, it works now !

Was this reply helpful? Yes No
Antony Stalin 15 on at

Like (0)

Report

As Alex replied changing TargetServerVersion is resolved the issue.

Since i'm using Visual studio 2015. Default version is "SQL Server 2016 or later". I have updated to "SQL Server 2008 R2, 2012 or 2014" and it works.

Thanks

Was this reply helpful? Yes No
Burim 450 on at

Like (0)

Report

Thank You....

Was this reply helpful? Yes No