<div>
Sounds like you intend to create 25 versions of the same report.<br />
Are you aware that there are 3rd-party Crystal Reports viewers/schedulers that allow you to switch the ODBC DSN on the fly?<br />
This means that interactively, the user can select from a list of alternative DSNs to use. Or via a setting/argument you can direct the process to use a different DSN.<br />
See: <a href="http://kenhamady.com/productlinks/default.html" rel="ugc">http://kenhamady.com/productlinks/default.html</a>
</div>


<div>
Thank you Ido, I put a request in with Report Tag earlier, still waiting for a 14 day trial download link. I don't need to schedule as I'm already using Ripplestone. I'm trying to make the tedious manual task changing the DSN for each sub-report for each site that will utilize the same report.<br />
<br />
I have 25 physical DSN locations and another 25 local archived database DSN's used as a database warehouse.
</div>


<div>
Does each subreport get a different data source?<br />
<br />
How often does the report change?<br />
<br />
Doesn't Ripplestone have that ability?
</div>


<div>
Each sub report gets the same data source, just different to connect to each new site.<br />
<br />
The report's data source changes for every new site (Hub and spoke, central database warehouse)<br />
<br />
after you configure the data source you will configure the same dsn data source in Ripplestone (these are already configured and working)<br />
<br />
My tedious challenge is updating the report to each new location as I have to physically open each &nbsp;sub-report and manually change the data source connection.
</div>


<div>
I wanted to share more details:-<br />
<br />
I attached the actual report. Also see below DNS sourcelist when I change a report location, as mentioned I have to do this for each subreport as the main report does not have an actual datasource:-<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w44/1204154/ODBC-Selection.png" target="_blank" title="ODBC Source selection for each sub report (46 KB)"><img alt="ODBC Source selection for each sub report" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w44/800_1204154/ODBC-Selection.png" /></a><br />
Below image is all the sub reports that has to be updated manually:-<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w44/1204155/Subreports.png" target="_blank" title="Below are all the subreports that needs to be updated to the same DNS source (51 KB)"><img alt="Below are all the subreports that needs to be updated to the same DNS source" class="file-block lazyload" style="max-width: 779px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w44/1204155/Subreports.png" /></a>
</div>


Below are all the subreports that needs to be updated to the same DNS source

Subreports.png

ODBC Source selection for each sub report

ODBC-Selection.png

<div>
I don't like using sub reports and have tried adding a data source to the main report, with all the current sub reports in place as is the processing goes of the wheels when I add data source to the main report. I will play around with adding a data source to the main report.<br />
<br />
Thanks.
</div>


<div>
Just add the data source. &nbsp;No need to link it tot he subreports or to have a query for the main report.<br />
<br />
If it is the same source as the subreports I believe changing it will also change the subreports<br />
<br />
mlmcc
</div>


<div>
I was able to get thru this by adding a source to the main report and changing the source to another DNS connection. After all the sub-reports synced I was able to get the report to process without errors. I was also able to create the same report for all sites (DNS connections)<br />
<br />
Thanks.
</div>


<div>
<div class="content wysiwyg-content">
I have a Crystal Report (2016) with multiple sub reports, I'm distributing the same report to multiple ODBC data sources (25). Is there an easier way to change the ODBC data source for each sub report rather than having to manually change each sub report ?
</div>
</div>


I have a Crystal Report (2016) with multiple sub reports, I'm distributing the same report to multiple ODBC data sources (25). Is there an easier way to change the ODBC data source for each sub report rather than having to manually change each sub report ?

Change data source for multiple subreports in Crystal

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.