Visual Studio 2010 Crystal Reports 2011 Hardcoded package names

[Former Member]

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

[former_member188030 · Accepted solution]

Hi,

Currently, there is no .Net SDK available with Crystal Reports 2011.

Migrate the report to [Crystal Reoprts for Visual Studio 2010|CystlR%2528SAPWeblogs%253ACrystal+Reports%2529]

Thanks,

Bhushan.

[Former Member]

Thanks Bhushan.

[Former Member]

We use Crystal Reports 2011 to builld the reports but we do have Crystal Reports for Visual Studio 2010 installed so we can integrate the reports into Visual Studio.

It's no big deal if we have to hardcode the package names - but i thought there might be a cleaner way of doing this.

[former_member188030]

Hi,

Retrieving the package names is out of the scope of Crystal .NET SDK as this is something from the Oracle end.

Some Custom logic can be implemented to include the package name dynamically based on the report.

Thanks,

Bhushan.