locked
Sql code of report RRS feed

  • Question

  • I want see the sql code of himself the made report in CRM. Is that possible ?

     

    Monday, October 22, 2007 10:08 AM

Answers

  • Hi,

    If you are trying to ask if it is possible to checkout SQL code of SRS Reports in MS CRM than yes, it is possible with the help of some SRS Report Designer. Remember to always use Filtered Views for quries.

    SRS Report's RDL file is basically a XML file containing SQL queries and other stuff.

    Monday, October 22, 2007 10:14 AM
    Moderator
  •  

    Hi,

     

    In order to view the SQL code of the report, you must first get hold of the report definition file (XML). You can get this from your supplier or by going to the reports section in CRM and download the report from the actions menu. Once you get hold of this file, then you can open it in Visual Studio (if it has the Reporting installed as well). In Visual Studio you can get to the source of the code.


    Ofcourse you can also open the XML file in notepad or your favorite xml viewer and look for the SQL code.

     

    Good luck,

     

    Ronald Lemmen

    Monday, October 22, 2007 4:35 PM
    Moderator

All replies

  • Hi,

    If you are trying to ask if it is possible to checkout SQL code of SRS Reports in MS CRM than yes, it is possible with the help of some SRS Report Designer. Remember to always use Filtered Views for quries.

    SRS Report's RDL file is basically a XML file containing SQL queries and other stuff.

    Monday, October 22, 2007 10:14 AM
    Moderator
  •  

    Hi,

     

    In order to view the SQL code of the report, you must first get hold of the report definition file (XML). You can get this from your supplier or by going to the reports section in CRM and download the report from the actions menu. Once you get hold of this file, then you can open it in Visual Studio (if it has the Reporting installed as well). In Visual Studio you can get to the source of the code.


    Ofcourse you can also open the XML file in notepad or your favorite xml viewer and look for the SQL code.

     

    Good luck,

     

    Ronald Lemmen

    Monday, October 22, 2007 4:35 PM
    Moderator