Skip to main content
R
RichardG
Inspiring
August 22, 2009
Question

BIG Problem with generating multiple pdfs

  • August 22, 2009
  • 2 replies
  • 1040 views

Hi,

I have an application for which the final output is a pdf report about an applicant from a database of applicants.

If I print the form just once, all the stylesheet formatting is applied correctly.

If I try to loop through the database and generate multiple reports of multiple applicants, the styles and formatting get applied ONLY to the first report, and then the subsequent reports do not have any styles applied which of course makes them unacceptable.

I've tried loading the stylesheet before the loop and inside the loop, no difference.

The styles being lost are for divs and tables and cells.  Fonts are handled separately by calling functions within the report which apply them on the fly.to text based on the section and type of output.

Is anyone familiar with this problem?  Is there a workaround? I really really really need this to work.

Thanks,

RIchard

This topic has been closed for replies.

2 replies

A
Anonymous
July 21, 2021

Richard,

may I know how to generate multiple reports from excel in Adobe prepare form?

do you write any script to do the process?

I have around 500 students record, and I need to populate Database and marks, every time I need to select one row from excel and prepare form, and it's a big process. 

similar to Mail merge (from image), is there any options in Adobe to generate multiple reports from excel?

 

regards
kowsi

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
July 25, 2021

@19393898 ,

You can use ColdFusion to solve your problem in the following simple way:

  1. Write a ColdFusion component (CFC) containing the function, generateReport. The function has one string argument representing the absolute path to an Excel file.
  2. Within generateReport, use cfspreadsheet to read the Excel file whose path is the value of the argument. The result of cfspreadsheet can be a query, for example.
    Loop through the query, and generate a PDF report for each row.

 

A
Anonymous
July 27, 2021
Hi BKBK,
Thank you!
Let me try CF and get back for any doubts

Regards,
Kowsi
--
Sent from my iPhone 🎋
-
-__cfSearching__-
Inspiring
August 26, 2009

I do not know the cause, but if all else fails you could move the cfdocument code to a separate template.  Then the styles seem to work as expected.

    <!--- loop code --->

    <cfloop from="1" to="5" index="x">

          <!--- call separate script cfinclude, cfmodule, etcetera ... --->
          <cfinclude template="test.cfm?x=#x#">
     </cfloop>

     <!--- test.cfm --->

    <cfdocument format="pdf" filename="testpdf-#url.x#.pdf" overwrite="true">
        <div style="background-color: #ff0000;">Test div</div>
    </cfdocument>

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices