This is a migrated thread and some comments may be shown as answers.

Opening TRDX that have differenct connectionString

1 Answer 82 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Dadan
Top achievements
Rank 1
Dadan asked on 22 Oct 2014, 04:42 AM
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-




1 Answer, 1 is accepted

Sort by
0
Accepted
Nasko
Telerik team
answered on 24 Oct 2014, 02:50 PM
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.

 
Tags
Report Designer (standalone)
Asked by
Dadan
Top achievements
Rank 1
Answers by
Nasko
Telerik team
Share this question
or