Opening TRDX that have differenct connectionString

2 posts, 1 answers
  1. Dadan
    Dadan avatar
    2 posts
    Member since:
    Feb 2010

    Posted 21 Oct 2014 Link to this post

    Hi,

    I have a report (trdx) file that i've copied from the remote server. i copied it to my local PC. ( i have also restored the database to my PC). i built the report with the same version of Telerik Report Designer. Q2 2014 ver. 8.1.14.804

    due to connection and location problem, i have to make a modification with the report locally in my PC, so i copy and open it.

    then, the Report Designer goes "loading..", but never finish loading the report. hang, it shows "not responding" in windows task manager, so i have to force close it, again, and again. i've waited for a long time, but it never finish loading it. do i have to build it again from the start? really?

    maybe it has something todo with the connectionString. i dont know.

    it's happen everytime when i want to change a report that connectionString's is not actually connected at the moment.

    its fine when i open a report (trdx) that have connectionString with my local DB in my PC.

    so, is there anyway that i can open and modify the report (trdx) ?

    Thank you for your kind attention.

    -Hariadi-




  2. Answer
    Nasko
    Admin
    Nasko avatar
    909 posts

    Posted 24 Oct 2014 Link to this post

    Hello Hariadi,

    Thank you for contacting Telerik Support.

    This behavior is caused by the connection strings which are not valid in the context of your PC. Since the connection strings are not valid on your PC, the Report Designer has to wait for the connection timeout time to pass before it can continue loading.
    This behavior is logged in our system for improvement in a future version of the Reporting suite.

    In the meantime you can modify the connection strings before opening the report in the Report Designer using a plain text editor. Open the report TRDX file in the text editor and modify/remove the elements under the DataSources node in the XML:
    <?xml version="1.0" encoding="utf-8"?>
    <Report DataSourceName="sqlDataSource1" Width="6.5in" Name="RowCountsSample" xmlns="http://schemas.telerik.com/reporting/2012/3.6">
      <DataSources>
        <SqlDataSource ConnectionString="AdventureWorks" SelectCommand="select * from humanresources.employee" Name="sqlDataSource1" />
      </DataSources>
    ...


    Regards,
    Nasko
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. DevCraft banner
Back to Top