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 ?
You can force open it by Right click on RDL file and click on View Designer to see the RDL in design mode.
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).
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.
Rename report as '.rdlc' it will open in design mode in Visual studio 2012
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With