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