SAP Knowledge Base Article - Public

1184035 - RDC Location property does not return the full path to a PC database using a native driver in Crystal Reports 10 and XI.

Symptom

Report Designer Component (RDC) .Location property does not return the full path to a PC database using a native driver in Crystal Reports 10 and XI.

Resolution

There is a difference in code between RDC version 9.0 and versions 10 and XI.

RDC version 9.0 uses the following code to change Location in an Access Native report:

Report.Database.Tables(1).SetTableLocation "c\test\new.mdb", "New Table Name", ""  Report.Database.Tables(1).Location returns the full path to the .mdb i.e. "C:\Temp\Xtreme.mdb"

RDC versions 10 and XI use the following code to change the tablename:

Report.Database.Tables(1).Location "New Table Name" Report.Database.Tables(1).Location returns the table name. Report.Database.Tables(1).SetTableLocation "c\test\new.mdb", "New Table Name", "" will also change the table name.

The change in the return value of Report.Database.Tables(1).Location may cause a problem upgrading a version 9.0 or earlier Project.

Keywords

RDC report designer component change Location Access Native SetTableLocation , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 10.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2