a stored procedure

[jwa6]

Hi
we are using 8.5 CR. I have a complex report calc to do. I can only see doing this calc in an Oracle SP. , which I have some experience with. I have seen here that the report tool can use "a stored procedure". I cannot find much in help(again).

does anyone have anything out there in the ether they can point me too?


help!!!!!
jim

 

[fredp1]

There are 2 papers on the BO Support web site.
SCR_Oracle_Stored_Procedures.pdf
storproc.pdf

I've had a little experience with sp on SQL server, but basically I found that you cannot link to a table if you have a sp as the datasource, because it is not generating SQL. It uses a exec statement.

the report will use paramaters from the sp.
If you what to use the CR paramters to pass to the sp, then you must put the sp in a subreport and link to the parameters.

Passing multivalues to a sp must be coded in the sp.
e.g. in CR you can have a date range. In the sp its 2 seperate paramaters fdate, ldate etc.

thats what I found when using sp.

Have you tried posting what the problem is in CR thats making you choose a sp?
There are some creative solutions out there.

I hope that helps.

Fred

 

[Nuffsaid]

Hi,

I agree with Fred.

Crystal is quite capable of performing complex calculations.
State your probem with specifics.

There's quite a bit of "qualified help" here.


Nuffsaid.

 

[Madawc]

As Nuffsaid says, Crystal can do complex calculations, maybe using several formulas or running totals.

Stored procedures are very good when you need to compare records within a table that are not next to each other when you read them. Or when you want to assemble data from several different sources, which Crystal can do but stored procedures do better.

Madawc Williams (East Anglia)