Home » Developer & Programmer » Application Express & MOD_PLSQL » Layout of a report (APEX 4.0)
Layout of a report [message #542862] Fri, 10 February 2012 09:34 Go to next message
balckbandit5
Messages: 104
Registered: December 2011
Senior Member
Hello Smile

I have a question; Is it possible to display a report like this:
e.g. source:
Select ROLE,
COMMENTS,
APPROVED
from ROLE


---------------------------------------------
| ROLE 1         ROLE 2          ROLE 3     |
| comments       comments        comments   |
| approved       approved        approved   |
|                                           |
|                                           |
| ROLE 4         ROLE 5          ROLE 6     |
| comments       comments        comments   |
| approved       approved        approved   |
---------------------------------------------

kind of like the vertical report layouts but horizontal


And also within a tabular form/report can I make the rows editable conditionally? i.e. if you belong to that role you can edit it, if not you can't (based on table ROLE , USER_ID)


Thanks
Re: Layout of a report [message #542864 is a reply to message #542862] Fri, 10 February 2012 10:08 Go to previous messageGo to next message
c_stenersen
Messages: 254
Registered: August 2007
Senior Member
1) Not that I know of. Then I believe you'll have to use a PL/SQL region and do the work yourself.
2) I don't think so, no. You could create the editable report yourself by using the apex_item package though, and then you can use whatever conditions you want for determining whether or not to show an editable field. http://docs.oracle.com/cd/E14373_01/apirefs.32/e13369/apex_item.htm
Re: Layout of a report [message #543106 is a reply to message #542864] Mon, 13 February 2012 02:35 Go to previous message
balckbandit5
Messages: 104
Registered: December 2011
Senior Member
Ok nevermind, thanks.
Previous Topic: ORA-01008: not all variables bound
Next Topic: Timestamp Date = item
Goto Forum:
  


Current Time: Fri Jul 25 11:14:48 CDT 2014

Total time taken to generate the page: 0.05601 seconds