question

Biju avatar image
Biju asked

SSRS 2014 installation

My Client is using SQL Server 2014 and so I want to create some reports in SSRS 2014. So I installed SQL 2014, VS 2013 and SSDTBI_x86_ENU. Then loaded "SQL Server Data Tools for Visual Studio 2013" under menu "Microsoft SQL Server 2014" and created a sample report.

But the Report Schema when checked we found it like 2008 R2 as shown below

<?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">;

.......

Please tell us What should we do to use 2014 SSRS instead of 2008 R2 SSRS

ssrs
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

wisey avatar image
wisey answered

In the project properties you need to make sure the targetserversion is set. SSRS 2014 uses the same xml schema 2008 r2.


targetversion.jpg (66.1 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Biju avatar image
Biju answered

Hi,

Thank you for confirming that SSRS 2014 is using the same xml schema of RS 2008 R2.

I am facing a problem while adding an custom control to SSRS 2014. There is no issue when I add one Custom control for generating QR Code from a third party assembly named "Gma.QrCodeNet.Encoding.dll" to 2013 VB.Net solution and it is working fine. But when I am adding the same control to SSRS 2014, I am getting an exception (screenshot attached) like "The following controls were successfully added to the toolbox but are not enabled in the active designer:

Make sure the controls to add are compatible with the current designer and .NET Framework version."

We can see the controls in RS Toolbox, but not enabled due to the above exception. Please help me.

Thanks in advance. qrdoubt1.jpg


qrdoubt1.jpg (149.6 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.