OraFAQ Forum: Reports & Discoverer » Reports 6i ref

Home » Developer & Programmer » Reports & Discoverer » Reports 6i ref_cursor (Reports 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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 ........' ;

Report message to a moderator

Re: Reports 6i ref_cursor [message #656809 is a reply to message #656805]

Wed, 19 October 2016 14:11

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know, I didn't try it. However, when I have to use such a "dynamic" WHERE clause, I create a lexical parameter, set its value in After Parameter Form trigger and use it in a main query; for that option, I *know* it works.

Report message to a moderator

Re: Reports 6i ref_cursor [message #656833 is a reply to message #656809]

Thu, 20 October 2016 04:25

petko
Messages: 2
Registered: October 2016

Junior Member

Lexical in PLSQL ?

Report message to a moderator

Previous Topic:	Ho we can use "with t as" in reports query
Next Topic:	Print Field Text in Vertical Direction

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 29 00:33:36 CDT 2025