Skip to Content
author's profile photo Former Member
Former Member

Updating Oracle Driver Results in 1 Report Displaying Blank Page - Tough One

I've updated a bunch of reports from XI to 2013 and updated the driver from ADO to Oracle Server. The reports call Oracle procedures that return a SYS_REFCURSOR and this works for about 30 reports...but 1 report just displays a blank page.

This is a dynamic query, so I was able to output the query and verified it returns data.

I've run the procedure as the report login and verified output.

I replaced the dynamic query with hard coded SQL...still a blank page.

If I use the ADO driver the report will display data.

If I create a table with the results the Oracle Server driver will display the report.

The report was fairly complex so I created a new report using the procedure and just placed some of the columns in the details, and it's also blank.

There was a parameter called Page that I thought might be a Crystal keyword that I changed...same result.

I can't run the query from Crystal as it utilizes WITH blocks.

Procedure parameters:

(

REPORT_YEAR VARCHAR2,

SITE_ID VARCHAR2,

S_PAGE INT,

SHOW_OBSERVERS INT,

P_CURSOR OUT SYS_REFCURSOR)

Output Columns:

DEPARTMENT OBS_COUNT SITE OBSERVER POSITION SITE_ID CREATE_DATE EXEMPTED

Any ideas?

Any ideas on how to capture the data being sent to the report outside of Oracle?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Dec 27, 2013 at 05:34 PM

    Hi Richard,

    I don't think your SP is formatted as CR requires.

    Search for this KBA:

    1181947 - Oracle Stored Procedures and Crystal Reports


    Make sure the user has permissions to the tables, CR fully supports DB security.


    Don

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 03:48 PM

    The Oracle Server driver requires the date format to be YYYY/MM/DD, where the ADO driver was much more forgiving.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.