Apex Code Development You need to sign in to do that
Don't have an account?
VENKAT32 How to break a visual force PDF containing a table of Line items
hi
i got the similar problem to break a PDF page , i have a quote with line items table, when the line items are more the table automatically going to second page but its is overlapping with the header on the second page , i want the table to be continued after the header ,
the following is my vf code:
<apex:page Controller="MyController32" RenderAs="pdf" >
<html>
<head>
<style type="text/css" media="print">
@media print
{
table {page-break-inside:auto }
tr { page-break-inside:avoid; page-break-after:auto }
thead { display:table-header-group }
}
@page {
@PageBreak{
page-break:always;
page-break-inside:avoid;
}
size:landscape;
@bottom-right {
content: "Page " counter(page) "of " counter(pages);
}
@top-center {
content: element(header);
}
@bottom-center {
content: element(footer);
}
}
div.header {
padding: 10px;
position: running(header);
}
div.footer {
display: block;
padding: 1px;
position: running(footer);
}
</style>
</head>
<!--header-->
<div class="header">
<table border='0'>
<tr>
<td height = '100'>
<apex:image id="theImage" value="{!$Resource.harlanlogo}" width="136" height="65"/>
</td>
</div>
<!--table-->
<body>
<div>
<table border ='1'>
<thead>
<tr>
<th>Number</th>
<th>M/F</th>
<th>Product</th>
<th>Description</th>
<th>Purpose</th>
<th>Item Price </th>
<th>Final Price </th>
<th>Packing Costs</th>
<th>Freight Costs </th>
<th>Total Costs</th>
</tr>
</thead>
<tbody>
<tr>
<apex:repeat value="{!Quoteproduct}" var="a">
<tr style="page-break-after:auto;">
<td>{!FLOOR(a.Quantity__c)}</td>
<td>{!a.Sex__c}</td>
<td>{!a.Product__r.Description}</td>
<td>{!a.Product__r.Name } {!a.Age_Weight__c }</td>
<td>{!a.Purpose__c}</td>
<td>{!IF((a.Product__r.Family =='Package'||a.Product__r.Family=='Freight'),0,a.Sales_Price__c)} </td>
<td>{!IF((a.Product__r.Family =='Package'||a.Product__r.Family=='Freight'), 0 ,a.Discounted_Price__c)} </td>
<td>{!IF((a.Product__r.Family =='Package'),a.Sales_Price__c,0)}</td>
<td>{!IF((a.Product__r.Family =='Freight'),a.Sales_Price__c,0)} </td>
<td>€ {!a.Total_Price_QP__c}</td>
</tr>
</apex:repeat>
</tr>
</tbody>
</table>
</div>
</body>
</html>
</apex:page>
Under the @ page{ } use the margin-top:10%; style :
@page
{
size:landscape;
margin-top:10%;
.
.
.
}
Hope this helps.
Thanks Pradeep, i got that, Is there a way to get the Table column headings on the second page also..
I need the answer to this also.
thead { display : table-header-group;} is not working
Hi
I have done a Work around for that,i wrote multiple SOQL queries in my controller for getting 10 opp lines and 20 opp lines ,and i used the apex tag as follows
count_line__c is rollup count of quotelines on quote
controller:
QP1 = [select id,name,Quantity__c,product__c, Product__r.Name,S_no__c, Product__r.Family ,Product__r.Description , Age_Weight__c ,Purpose__c,sales_Price__c ,Discounted_Price__c,Sex__c, Total_Price_QP__c
from Quote_Product__c where Quote__c =:Q.Id and (S_no__c >= 16 and S_no__c<35)];
QP2 = [select id,name,Quantity__c,product__c, Product__r.Name,S_no__c, Product__r.Family ,Product__r.Description , Age_Weight__c ,Purpose__c,sales_Price__c ,Discounted_Price__c,Sex__c, Total_Price_QP__c
from Quote_Product__c where Quote__c =:Q.Id and (S_no__c >= 35 and S_no__c<=53)];
paeg:
<apex:outputPanel rendered="{!QUOTE.Count_line__c >15}"> "Rendering a Visualforce page as PDF and force (https://salesforce.stackexchange.com/questions/55591/rendering-a-visualforce-page-as-pdf-and-force-page-breaks) editor (https://writemyessaytoday.net/) page breaks (https://salesforce.stackexchange.com/questions/55591/rendering-a-visualforce-page-as-pdf-and-force-page-breaks).
https://salesforce.stackexchange.com/questions/55591/rendering-a-visualforce-page-as-pdf-and-force-page-breaks link (https://casinority.com/real-money/) works for me just perfectly, of course you may also try https://salesforce.stackexchange.com/questions/55591/rendering-a-visualforce-page-as-pdf-and-force-page-breaks. Good luck!