Search code examples
databasecrystal-reportsreport

Adding another data source to existing rpt file Crystal Report

Dears,

Can you please help me if there is a way to add another data source to existing report (rpt file) that I have on production environment, but I only have rpt file not the whole solution.

I tried to add new connection and add the fields I want, but multiple datasources warning appear and rpt file will show blank in browser once I opened it. I tried also to add subreport which depend on the new data source and I linked it with the main report but still same issue blank report in production environment.

Any help will be appreciated.

Thanks

Update:

  • This is the existing fields in the original rpt file:

Existing Fields

  • Database Fields > Database Experts, adding new connection:

I added new connection, you can see it down

  • After adding, VS will ask me for the old XML File which I don't have it so I will just click cancel then the new fields will be added to Database Fields. At this point, rpt file will be shown as blank. Any help with this issue?

VS Asking for old XML

Solution

  • Sounds like you need to replace the data source (old XML file) with a new data source (new XML file). In that case, use the menu option of: Database, Set Datasource Location...