Change data source for multiple subreports in Crystal

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 ?
John-S PretoriusTechnical Service Manager, Mid-AtlanticAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Have you tried giving the main report the same data source?

I believe when you update that one it will update the sources for the susbreport.

mlmcc
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Sounds like you intend to create 25 versions of the same report.
Are you aware that there are 3rd-party Crystal Reports viewers/schedulers that allow you to switch the ODBC DSN on the fly?
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.
See: http://kenhamady.com/productlinks/default.html
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
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.

I have 25 physical DSN locations and another 25 local archived database DSN's used as a database warehouse.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
mlmccCommented:
Does each subreport get a different data source?

How often does the report change?

Doesn't Ripplestone have that ability?
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
Each sub report gets the same data source, just different to connect to each new site.

The report's data source changes for every new site (Hub and spoke, central database warehouse)

after you configure the data source you will configure the same dsn data source in Ripplestone (these are already configured and working)

My tedious challenge is updating the report to each new location as I have to physically open each  sub-report and manually change the data source connection.
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
I wanted to share more details:-

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:-

ODBC Source selection for each sub report
Below image is all the sub reports that has to be updated manually:-

Below are all the subreports that needs to be updated to the same DNS source
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
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.

Thanks.
0
 
mlmccCommented:
Just add the data source.  No need to link it tot he subreports or to have a query for the main report.

If it is the same source as the subreports I believe changing it will also change the subreports

mlmcc
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
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)

Thanks.
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.