Crystal Reports 8.5 and Oracle 1

[mrm312]

Trying to integrate Crystal reports with an Oracle web application. Is there a way to call and open the reports from PL/SQL?

Thanks,
Mike

 

[synapsevampire]

Not sure what Oracle WEB Server supports, but Crystal cannot be executed at the command line.

Here are the sample apps using various methodologies:

http://support.businessobjects.com/fix/samplescr.asp?ref=default.asp_selectlist#04

-k

 

[mrm312]

Thanks! From the research I have done and the feedback I have received, it seems that Crystal Reports and ORACLE do not interface well.

Appreciate the link I'll comb throught it and see if there is any useful information.

...may need to just use Oracle Reports.

Thanks again,
Mike

 

[Turkbear]

Hi,
In Oracle forms you can create a menu item that will call a Crystal Report, and you may be able to do it within Pl/Sql with a HOST-type command- I do not know the exact method, but ultimately you need to send a URL like this one:

[URL unfurl="true"]http://YourCeServer/viewrpt.cwr?id=126311&apsname=Guest&apsauthtype=secEnterprise[/URL]

adding any parameters and values for them..


Search the Business Objects support site for a document called
SCR8_URLCMDs.pdf

It list all the commands that can be used in aURL to call a report.

 

[synapsevampire]

Crystal and Oracle work fine together, in fact Crystal supplies a Native driver which is relatively fast, and a proprietary ODBC driver, which you should use in lieu of Oracles.

-k