OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » APEX template

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » APEX template :: Multi-columned report (Application Express 3.1.2.00.02)

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

APEX template :: Multi-columned report [message #440337]

Fri, 22 January 2010 09:26

roseline43
Messages: 10
Registered: October 2009

Junior Member

I want to make a multi-columned report in APEX.

I managed to do a 3 columned report as follow:

SMITH  ALLEN
       WARD   JONES    MARTIN
       BLAKC  CLARK    SCOTT
       KING   TURNER   ADAMS
       JAMES  FORD     MILLER

Here is my template code:

Template Class: Standard
Template Type: (column template)

[b]Before rows:[/b]
<table cellpadding="0" border="0" cellspacing="0" summary="">
#TOP_PAGINATION#
<tr><td><table cellpadding="0" cellspacing="0" border="1" summary="" class="t9ValueAttributePairs">

[b]BEFORE EACH ROW[/b]
<td><table cellpadding="0" border="0" cellspacing="0" summary="">

[b]COLUMN 1 MODEL[/b]
<tr><td class="t9data">#COLUMN_VALUE#</td></tr>
CONDITION COLUMN 1
PL/SQL
mod(#ROWNUM#,3) = 0

[b]COLUMN 2 MODEL[/b]
<tr><td class="t9data">#COLUMN_VALUE#</td></tr>
CONDITION COLUMN 2
PL/SQL
mod(#ROWNUM#,3) = 1

[b]COLUMN 3 MODEL[/b]
<tr><td class="t9data">#COLUMN_VALUE#</td></tr>
</table></td>
<tr></tr>
<td><table cellpadding="0" border="0" cellspacing="0" summary=""><td> </td>
mod(#ROWNUM#,3) = 2
CONDITION COLUMN 3
PL/SQL
mod(#ROWNUM#,3) = 2

[b]AFTER EACH ROW[/b]
</table></td>

[b]AFTER ROWS[/b]
</table></td></tr>#PAGINATION#</table>

MY QUESTIONS:

1) the result that I have now is almost right but the Name SMITH and ALLEN are not well align.
There might be something wrong with my template definition ( see my template code before)

2) IS it possible to have more than 4 column model ( I need 8 or maybye 12 ). How can I modify this template?
If not, How can I modify the template to have a 8 or 12 columns templates?

thanks

Roseline

Report message to a moderator

Re: APEX template :: Multi-columned report [message #440566 is a reply to message #440337]

Mon, 25 January 2010 14:44

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Personally, I'd create an HTML table in the report cell, to align the detail like in this example...
http://apex.oracle.com/pls/otn/f?p=daust_demos:nested_report:4374335957664003

Report message to a moderator

Re: APEX template :: Multi-columned report [message #440678 is a reply to message #440566]

Tue, 26 January 2010 10:29

roseline43
Messages: 10
Registered: October 2009

Junior Member

I will tried that.

Thanks a lot.

I almost achive wuaht I want with CSS:

I used this CSS based example:
[URL] http://apex.oracle.com/pls/apex/f?p=23415:2:8[URL]

I want a multiple column table looking like that. But the only thing is that I need the DVD name on one line, and all the files under, in a table.

I created a report based on the example.
I used ventilation on my 1st column

and here is the result (see JPEG)

My report is like that:


Named column (row model) 

ROW MODELE (1)
<li>
  
    <span>#1##2#</span>

</li>


Before rows:
<ul id="ul-table">

After rows:
</ul>

In my page, I added in the header:

<style type="text/css">


#ul-table li a {
background-color:#F4F7FA;
font: 12px Arial, sans-serif;
display:block;
line-height:40px;
}
#ul-table a:link, #ul-table a:visited, #ul-table a:active {
color: #255FDC; text-decoration: none;
}
#ul-table a:hover {
background-color:#CCD9E9;
color:navy;
text-decoration: none;
}
#ul-table {
width:562px;
text-align:center;
margin: 0px auto;
padding:0;
color: navy;
list-style-type:none;
clear:both;
}
#ul-table li {
width: 139px;
float:left;
border:1px solid navy;
border-right:none;
text-align: center;
}
* html #ul-table li a {
width: 100%;
}
#ul-table li.top {
border-bottom:none;
}
#ul-table li.right {
border-right:1px solid navy;
}
.clear {
clear:both;
margin-top:-1px;
height:1px;
overflow:hidden;
}


</style>

Is someone know how to modify the report template to achive that?
Mybye I need to use DIV instead of LI??

thanks,

Roseline

Attachment: example.jpg
(Size: 135.09KB, Downloaded 1843 times)

Report message to a moderator

Previous Topic:	How to deploy a developed program by apex
Next Topic:	Need suggestion in selecting Apex for new development

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 10:42:34 CST 2025