How to use multiple clauses using Lexical Parameter (merged 2) [message #437089] |
Thu, 31 December 2009 00:45 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mahmud732
Messages: 82 Registered: October 2009 Location: Dhaka
|
Member |
|
|
Dear all,
I have created a report in dev 10g with a lexical Paramater.
I also want to lexical parameter which help me to display multiple columns from a table.
My report SQL Query is:
Select &Lex_param;
Here &lex_param will be ename,empno,sal,comm from emp
Have any solution? Please...........
Regards
Sultan Mahmud.
|
|
|
Re: How to use multiple clauses using Lexical Parameter (merged 2) [message #437115 is a reply to message #437089] |
Thu, 31 December 2009 02:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I don't think that you can do that.
Reports, as of runtime point of view, requires predefined layout. It means that you have to create the layout (manually) and, once the report is run, display values in fields that are contained on that layout.
You can, though, manipulate with these fields using their Format Trigger property which returns Boolean; for example, if you create certain parameters that will decide whether to display a field or not, it would look like this:return (:par_display_hire_date = 1); which means that, if parameter's (par_display_hire_date) value equals 1, field will be displayed.
|
|
|