Skip to Content
0
Former Member
Jun 01, 2011 at 07:23 AM

Set datasource location and remapping fields in code instead of designer

46 Views

Dear all,

We are currently migrating a VS6 reporting project to VS2010. The old project has like 133 Crystal Reports XI release 2 reports.

All of these .rpt files need to have their datasource location changed and fields remapped because of a change in naming convention.

The datasource location is currently set to a stored procedure in an Oracle database and this will remain; only the name of the

stored procedure and the name of the fields returned are changed (due to new naming conventions).

Is there a way, and I really hope so, to programmatically change the datasource location and remap the fields (mind that these fields are also used in formulas, grouping, total, ...).

Doing this manually in the designer for like 133 times would be very time consuming.

After some research I stumbled upon the CrystalDecisions.ReportAppServer.Controllers.DatabaseController but I'm looking for some example usage, if this is the correct way.

The end result should be that all these 133 .rpt files have their datasource location changed and fields remapped.

Any assistance or pointers in the right direction would be kindly appreciated.

Thanks.