I'm working with LiveCycle Designer, and need to populate forms with specific database records. I need instructions, and a simple working example on how to pass by POST and QueryString, one or more criteria for use in the query or SP. An example of: [url removed, login to view];DateFrom=05/01/2007&DateTo=05/21/2007. Need for the PDF on open, receive such values as a variable if passed by querystring or Request method if passed by Post method., and the SQL STMT or SP to use the set vairables in the WHERE clause, thus populating the PDF with a specific record or list of records.
I am NOT looking for an alternate script to create a PDF. If an external script is required, it MUST allow for full use of designer in formatting text, objects, images, etc, and MUST NOT restrict functions available in Designer.
In your response, please take the time to indicate what you propose, so I'll know we're talking about the same solution.