Thanks Rachit for solution approach,

Meanwhile we tried implementing HTML Stream Rule to generate the PDF as the data from .txt files is parsed by application and stored within database in 3 different tables.

We were able to generate PDF Successfully to some extendt for a single file and multiple files we need to adhere to proper structure, but we are to retrieve the data from pagelist hence facing issues in structuring

Below is the structure of the clipboard :

UserPages

 --- HeaderPage - PageList

 --- PatternPage - PageList

 --- PatientPage - PageList

Java code we used to retrieve in HTML

<%

ClipboardPage headerPageTest = tools.findPage("HeaderPage");

ClipboardProperty headerTest = tools.getProperty("pxResults");

java.util.Iterator itr = headerTest.iterator();

java.util.Iterator Counter= headerTest.iterator();

int i = 0;

while(Counter.hasNext()) {

    i++;

    Counter.next();

}

if (i>0)

{

while(itr.hasNext())

{

 

 tools.appendString("<TR>");

 tools.appendString("<TD class='bottom' style='text-align: center;'>In While Loop"+ i+"</TD>");

 tools.appendString("</TR>");

}

}

%>

As headerTest is not retrieved with pxResults, there is no value being displayed in PDF. Can you please help how we can retrieve data directly from userpages created.

We were able to retrieve the results using for each jsp tag, but as we cannot track the index of list items unable to add new line as needed for PDF Format.

Current Format:

    1 BAC

    2 ABC

    3 CBA

    4 ABC

    5 CBA

    6 ABC

    7 ABC

    8 BAC

  

Expected Format:

1 BAC

    2 ABC

    3 CBA

    4 ABC

    5 CBA

    6 ABC

    7 ABC

    8 BAC

Please suggest if there is any jsp tag to create count variable and increment same within foreach tag, so that we can add when condition tag and achieve above format.

Our Application is on Pega 6.3, is merging of pdf possible in this version.