| help order by parameter radio buttons [message #552866] |
Sun, 29 April 2012 15:16  |
doooos
Messages: 3
Registered: April 2012
Location: dubai
|
Junior Member |
|
|
i have 2 files rep.rdf and rep.fmb
i made parameters for userid and dept its working fine but
how can i make order by parameter using radio buttons
what i add in report and form ?
|
|
|
|
| Re: help order by parameter radio buttons [message #552882 is a reply to message #552866] |
Mon, 30 April 2012 00:48  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
How is ORDER BY clause supposed to look like? What would these radio buttons do? Choose among which values?
Anyway: there are two options I can think of. The first one is to compose the ORDER BY clause in a form and pass it to a report as a parameter. Another one is to pass radio button's value to a report (as a parameter), and let report's After Parameter Form trigger create ORDER BY clause, store its value into a lexical parameter which would then be used in report's query.
For example: -- After Parameter Form trigger
...
if :par_radio_button = 1 then
:lex_order_by := ' order by deptno, empno';
else
:lex_order_by := ' order by empno, deptno';
end if;
-- Query
select ...
from ...
where ...
&lex_order_by
[EDITED by myself: removed superfluous empty lines]
[Updated on: Tue, 01 May 2012 02:52] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
