Reports 6i ref_cursor [message #656805] |
Wed, 19 October 2016 12:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/47ddc4577b994c4d153e27b1f6b66a14?s=64&d=mm&r=g) |
petko
Messages: 2 Registered: October 2016
|
Junior Member |
|
|
in OraRep 6i, i create rec_cursor with sql. then in the Data MOdel OraRep i create QR.
In the parameter report i have field with 4 option (A, B, C, D) and when user choosse one of the option sql in ref_cursor, i add more then one restriction (AND .......) on the query (ref_cursor).
is it possible to do something like this :
function QR_....
....
open ref_cursor for
if :parameter = A then
ref_cursor || 'AND ........';
elsif
:parameter = B then
ref_cursor || 'AND ........'
AND ........' ;
|
|
|
|
|