To display details in multiple pages in a PDF file

brindas1 over 7 years ago

Hi all,
In one of my application, I am generating a PDF file based on database query, which has a list of customers in grid format. In the PDF, all the customer details are getting displayed in a single page. How can I get the details being displayed in different pages? I tried using paging info, but no use.

Discussion posts and replies are publicly visible

0 aloks0189
Certified Lead Developer
over 7 years ago

@brindas you can try using PDF from XSLFO Smart Service
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandolum
A Score Level 1
over 7 years ago

@brindas can you tell us by using which smart service you are generating the pdf. If you are generating pdf using PDF from HTML smart service , the generated pdf will be always one page irrespective of the data. As Alok said you can use pdf from xslfo smart service to generate the pdf. I also faced the same situation before.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 brindas1 over 7 years ago

I am using PDF from HTML smart service. As you said, I will try the other option PDF from XSLFO smart service.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
+1 harshav over 7 years ago

Not tried though but what if you can create a single PDF file based on a user and user Merge PDF smart service and make it a s single file, so that you will get each name in a single pdf in different pages, Hope this would help, I tried Merge PDF and it is working for me, But the first part you can try using any smart service with an MNI
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 brindas1 over 7 years ago

@aloks, @chandolum I have tried using PDF from XSLFO Smart Service. I have created a sample student xml and xsl file. I have used the smart service in the process model to get the student details table in pdf. But when I tried to open the PDF it gave me the error as follows:
"There was an error opening this document. The file is damaged and could not be repaired".
Can you please explain why I am getting this error? How can I view the PDF?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandolum
A Score Level 1
over 7 years ago

@brindas, can you attach both the generated xml file and the xsl file, so that we can find the root cause.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 brindas1 over 7 years ago

studentsXML.xml file:
<?xml version="1.0" encoding="ISO8859-1" ?>
<?xml-stylesheet type="text/xsl" href="studentsXSL.xsl"?>

<CATALOG>
<CD>
<TITLE>Empire Burlesque</TITLE>
<ARTIST>Bob Dylan</ARTIST>
<COUNTRY>USA</COUNTRY>
<COMPANY>Columbia</COMPANY>
<PRICE>10.90</PRICE>
<YEAR>1985</YEAR>
</CD>
</CATALOG>

studentsXSL.xsl file:
<?xml version='1.0'?>
<xsl:stylesheet xmlns:xsl="www.w3.org/.../WD-xsl">
<xsl:template match="/">
<html>
<body>
<table border="2" bgcolor="yellow">
<tr>
<th>Title</th>
<th>Artist</th>
</tr>
<xsl:for-each select="CATALOG/CD">
<tr>
<td><xsl:value-of select="TITLE"/></td>
<td><xsl:value-of select="ARTIST"/></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 vinodn1 over 7 years ago

Hey, I'm facing the same issue. Have you been able to identify the cause ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandolum
A Score Level 1
over 7 years ago

@Vindn, brindas I'm trying to identify the issue, I've implemented pdf-xslfo approach for the dynamic data in my project, but when i'm trying for static data it's unable to read the xml file. will let you know once i found the root cause.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 brindas1 over 7 years ago

@chandolum have you identified the issue?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel