| Reports 6i ref_cursor [message #656805] |
Wed, 19 October 2016 12:35  |
 |
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 ........' ;
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
