OraFAQ Forum: Application Express, ORDS & MOD

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Layout of a report (APEX 4.0)

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

Layout of a report [message #542862]

Fri, 10 February 2012 09:34

balckbandit5
Messages: 104
Registered: December 2011

Senior Member

Hello

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

Report message to a moderator

Re: Layout of a report [message #542864 is a reply to message #542862]

Fri, 10 February 2012 10:08

c_stenersen
Messages: 255
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

Report message to a moderator

Re: Layout of a report [message #543106 is a reply to message #542864]

Mon, 13 February 2012 02:35

balckbandit5
Messages: 104
Registered: December 2011

Senior Member

Ok nevermind, thanks.

Report message to a moderator

Previous Topic:	ORA-01008: not all variables bound
Next Topic:	Timestamp Date = item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 16:49:56 CST 2024