Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » APEX template :: Multi-columned report (Application Express 3.1.2.00.02)
icon4.gif  APEX template :: Multi-columned report [message #440337] Fri, 22 January 2010 09:26 Go to next message
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
Re: APEX template :: Multi-columned report [message #440566 is a reply to message #440337] Mon, 25 January 2010 14:44 Go to previous messageGo to next message
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
icon11.gif  Re: APEX template :: Multi-columned report [message #440678 is a reply to message #440566] Tue, 26 January 2010 10:29 Go to previous message
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 461 times)
Previous Topic: How to deploy a developed program by apex
Next Topic: Need suggestion in selecting Apex for new development
Goto Forum:
  


Current Time: Tue Dec 06 14:36:47 CST 2016

Total time taken to generate the page: 0.10072 seconds