Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

I cannot open a SSRs RDL file in designer view. Why is this happening?

Tags:

I have just opened up a project that contains SSRs reports and yet I am unable to view them in Design Mode. When I click on them, only the XMLS appear and I am not sure how to resolve this in VS 2012 ?

like image 282
SamIAm Avatar asked Jan 22 '15 23:01

SamIAm


People also ask

How do I open an RDL File in design view?

You can force open it by Right click on RDL file and click on View Designer to see the RDL in design mode.

How do I open an RDL File in report Builder?

So, I have to check out the RDL file in the Source Control Explorer window, then pull up Windows Explorer, find the correct folder, and then double-click on the file to open it in Report Builder (which is the default association for RDL files on my system).


2 Answers

In a version of Visual Studio that includes SQL Server Report Services, create a new Report Server Project.

In the new Report Server Project, right-click the project node in the Solution Explorer and choose "Add" > "Existing Item...". Then browse to and select the RDL file. Once it is in a Report Server Project, you can right-click the report and choose "View Designer" to see it in Design View. By default, it ought to open in Design View anyway.

If the file is not part of a Report Server Project, you'll only be able to view the XML text. Depending upon the Version of Visual Studio you may (or may not) get XML highlighting and intellisense.

like image 128
Zarepheth Avatar answered Sep 20 '22 13:09

Zarepheth


Rename report as '.rdlc' it will open in design mode in Visual studio 2012

like image 30
Raviraj Avatar answered Sep 21 '22 13:09

Raviraj