Problem with CR XI report with Oracle Stored proc as source

[Videla]

Hi All,

I am trying to create a simple crystal report using Oracle stored proc as source. I am facing a strange problem..highly appreciate if someone can help me with this.

The source table data is as below.
BD bus_Desc
--------------------
FNIC Reg Director
PV Leg Entity
ALL sell_grp

Stored Procedure code using Ref Cursor is as below.

PROCEDURE test_ref (p_bd char, p_recordset OUT Types.cursor_type) AS
BEGIN
OPEN p_recordset FOR
SELECT bus_Desc from template where bd = p_bd;
END;

Now using CR designer i defined "test_Ref" stored procedure as source and dragged bus_desc column into the detail section. "p_bd" is automatically appeared in paramerter section. everythign is perfect.

We are using ASP.NET as front end, so my next step is integrating this simple reprot with .NET. We are using Visual Studio .Net for windows 2003 as IDE. When i copied this crysal report .rpt file to the server where IIS is running and accessed using Visual studion .NET, to my surprise there is no "p_bd" paramerter in parameter section of field explorer. I am not sure why it is not appearing!!and also in VS .NET, i observed that we can create a new item to the project in solution explorer. I created a crystal report using this and while specifying the source it is listing only Tables, Views but not stored procedures. I am wondering may be due to this parameter section is becoming empty when i copy the file created CR designer. Can someone pls help me in resolving this issue.

Thanks
Ravi

 

[synapsevampire]

Have you read this:

http://support.businessobjects.com/communityCS/TechnicalPapers/crxi_net_deployment.pdf

-k