Skip to Content
0
Former Member
Feb 17, 2011 at 02:25 PM

Where else is there connection info?

204 Views

I am going through a CR 2008 .rpt file using the 12.3 API. I am trying to set all data connections to point to the same source. I execute the code at the end of this post, which runs successfully. I check the properties of each table in the report and subreports, and they all appear to have the same properties when I am done. I save the report.

When I open the newly saved report in the designer, it shows the tables distributed between two or three different data sources, as you can see in the linked images. All of the data sources are derivative names of the original (i.e. the original name "_1" or "_2"), and they point to the same data source.

Why would it create different data source entries? Is there somewhere in the report document that table connection information is stored that I am not changing?

Thanks.

CR 12.3

.NET 4

[Image 1 - The different data sources with tables|http://digitalsamurai.us/images/CR01.jpg]

[The properties of each data source|http://digitalsamurai.us/images/CR02.jpg]

Posting my code here appears to mess up the format, so I will post it in the next post down.