Visual Studio 2010 Crystal Reports 2011 Hardcoded package names

35 Views

Hi. We are in the process of upgrading our software to Crystal Reports 2011, Oracle 11 and Visual Studio 2010. We have a small Visual C# application that opens up various Crystal reports. Some of the individual reports contain 20 to 25 subreports. The main report and every subreport returns a cursor from a stored procedure. Each stored procedure is housed in a different package. Everything works fine, but I dont really like that we have to hardcode the names of the packages that contain each stored procedure (for every report and subreport we use).

CrTable.Location = strTableOwner.ToUpper() + ".PACKAGE_NAME." + CrTable.Location;

Hardcoding the package name seems prone to errors. Is there a way around this so the Visual C# application can determine the name of the package that contains the stored procedure?

Thanks