Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS - Custom parameter layout was removed from the report

I installed a fresh copy of Visual Studio 2015 on a new computer as well as the SSDT December preview. Report server is SQL Server 2008 R2. I can view and build my reports successfully, no problems there, but for about half of the reports I get the following warning message:

Custom parameter layout was removed from the report. /
SQL Server 2014 Reporting Services and earlier do not support custom parameter layout.

The message appears every time I clean/rebuild, so something isn't changing permanently like VS claims. I don't even know what a custom parameter layout is, so I'm pretty sure I don't need to worry about this. How can I either disable the warning message or fix the problem it's complaining about?

like image 609
vaindil Avatar asked Dec 29 '15 17:12

vaindil


2 Answers

Edit: Confirming Jordan's comment. Disabling the XAML Designer no longer stops the ReportParametersLayout section from being generated.

Either ignore the message or manually remove the ReportParametersLayout section from each report.

Prior workaround: (No longer works as of Update 3) If I understand correctly, it appears the warning is caused by the XAML Designer in VS2015 sending data which is only compatible with SQL 2016 or later.

I'm guessing VS devs could resolve the issue if they add some logic to stop XAML Designer output when we select any "TargetServerVersions" earlier than 2016.

Until then, you could: 1.) Continue to ignore the warnings 2.) or you could disable XAML Designer so you will no longer get the warning messages. (Tools > Options > XAML Designer > Uncheck "Enable XAML Designer" then restart VS2015)

like image 158
Thor Avatar answered Sep 29 '22 06:09

Thor


You can just disable the custom parameter layout by commenting out or removing the <ReportParametersLayout>...</ReportParametersLayout> tags and all inside it in code view of the report.

like image 41
Eli Makumba Avatar answered Sep 29 '22 07:09

Eli Makumba