.rdl opens to XML code. Need Report Layout view.

  • Hi.  I'm new to SSRS with the exception of going through a few exercises to create a basic report, so this is my first time actually using it.  Some reports were written for us by another person who is unavailable for questions, and while we do have all rights and access to the reports, when we open the .rdl files, we get the XML view and not the Report Layout view, which is what we really need.  Can someone please point me in the right direction?  Thanks in advance.

    Tracey

  • Tracey,

    Suspect that your double clicking on the rdl's file name.  Instead, try opening the file using the open dialog box of the development tool your using.

    Mike

  • Tracey , go to the development tool , open any project

    Add the report by right clicking the reports(Go for existing report) and give the path where the report you want to open exists, Don't try to open the rdl file directly.

    Now you can see the report

    Thank you

    Raj Deep.A

  • I have the same problem. Created a few reports a couple weeks ago. Now when I open the project, file, solution, etc. the reports always open in xml view. How do you switch back to design view?

    Thanks

  • Same problem here, I'm opening the file in Visual Studio 2005 Pro and it opens in XML view. The file is in a project.

  • In the Visual Studio IDE right click on the rdl file and you will see a option to Open, View Code, View Designer options with additional option to deploy build etc, Choose view designer and it should take you to design mode. Infact by default when you click on open also it should open in design mode, but from your post I understand its not doing so. Try clicking on View Designer.

     

    Prasad Bhogadi
    www.inforaise.com

  • I just had the same issue. Make sure that the .rdl extension is still after your reportname...

    Good luck.

    Guido Ritzen

  • This can also happen if you are opening the file with a non SSRS project. Create an SSRS project then add >> existing item and browse for your file, then open it from within the project.

  • It will also happen if you try to open something developed in 2008 R2 with 2008 and vice versa. Different namespace.

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • Good Thread, thanks for the ideas so far. In my case I was unable to open an rdl on a client site that had both 2008 and R2 installed. The solution that worked for me was first open BIDS 2008(the product the report was developed in), create reporting services project and add the current report.

  • I just had a very simliar problem. It was on a report I'd developed myself and was occuring in the project in which I'd developed it. Clicking View Designer made no difference, neither did excluding it from the project and then re-adding it. I started whimpering quietly to myself at this point as visions of the dole queue swam across my minds eye.

    Then I saw the warning message "Data Type Attribute not declared". Hope blossomed as I selecetd View Code from the context menu and two more similarly worded warnings appeared. Double clicked 'em to take me to the offending xml tags and I was able to delete the "Data Type = Integer" attribute. Closed the designer window (which was still showing xml) and re-opened it to be presented with the glorious spectacle of my neatly laid out report, once more restored in all its tablixy splendour.

    I now need new underwear but that's ok. I'll still have a job tomorrow so I can afford it.

  • /

  • I have visual Studio 2015 and 2013 and I m having the same problem trying to open my reports in report designer too. I am opening from file- open - existing project -- didn't work. I also did add existing project and did not work either. Any idea?

    I found this link https://social.msdn.microsoft.com/Forums/en-US/9cf7b9b6-d8c2-41d5-a033-9d5110021249/unable-to-open-report-in-the-design-mode

    but didn't help me much

    Thanks

  • Try to start clean,in these cases. Create a SSRS project named like TempSSRShold for example. Then Right click the Reports node, add > existing item. From here navigate to the directory that has the Windows .rdl file and select it.

    If this is a newer version of SSRS than what the report was built with it , the dev environment will try to convert the report to the version of SSRS you have. If you are opening the report with an earlier version of SSRS, you are probably out of luck and should rebuild it new.

    I hope this helps someone.

    ----------------------------------------------------

  • I have Fixed mine.

    I found that there was some extensions issues, overthought I have the latest Enterprise edition, It could not work right because of some weird extension configuration error base on ... I don't know.

    Solution.

    1 - have Reset my extension Setting in VS CMD devenv /resetsettings ( didn't work for me)

    Next I uninstalled all versions of Visual studio on my Machine except the latest (2015 for me)

    I ALSO Uninstalled SS Data Tool

    Then I repaired my latest version. Reboot my system and Install SSDT and voila everything is working at perfection.

    Now I can open any File from any and every where. Well I m working (productively)

    THANKS

    @KZSQLDBQ

    Thanks

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply