You are not authorized to post a reply.
|
 Prev Next
|
| Author |
Messages |
|
charliesolomon
Nuke Expert
Posts:50
 |
| 08/29/2007 10:25 AM |
 Alert
|
The attached zip file contains a PDF file created with Adobe Acrobat Professional v8. It is a screen capture of our Pdf Reports products page from this site, which I then added one form field to (this requires the "Professional" version of Acrobat, unfortunately... there are other PDF creation tools out there but I have not verified them to work with Pdf Reports.)
I labeled the form field "Label1" in my PDF file. The zip file also contains an SQL script that will create the stored procedure Pdf Reports calls to fill your form. This example fills the form with UserName's from your DNN site (one per page, limited to the last 10 registered users.)
To set up the report, add a new report to your Pdf Reports module (which you have already installed on a page of your site). In the report settings page, give you report a name, specify the correct stored procedure name to call, and leave the report type as "PDF". Then click "Save".
Then, in the "Files" section of the report settings, upload the attached PDF form file ("Pdf Reports Form.pdf"), then select it as the "AcroForm" file from that dropdown.
Click "Save and Exit" and you are ready to test it out.
(Note: requires Pdf Reports v02.00.08 or later) |
Attachment: Pdf Reports Form.zip
|
Charlie Solomon
Beldin Technologies |
|
|
mikerennick
Regular Poster
Posts:16
|
| 07/21/2008 6:46 AM |
Alert
|
If I create an AcroForm with the following form fields (in this order):
FirstName, Lastname, FirstName, StreetAddress, FirstName
then would my final sql query look like this:
SELECT FirstName, Lastname, FirstName, StreetAddress, FirstName FROM Table
In other words, do I need to select fields in my query in the exact order and quantity to the form fields used int he AcroForm? Or, can I map the fields from the query by using the same Name as the form field used on the acroform. If that were true, then my query might look like this:
SELECT FirstName, Lastname, StreetAddress FROM Table
where the value of FirstName will map to the AcroForm form field called "FirstName"
|
|
|
|
|
charliesolomon
Nuke Expert
Posts:50
|
| 07/22/2008 1:23 AM |
Alert
|
Hi Mike,
Order does not matter. Quantity does not matter. Uniqueness does matter (I think... you may want to test this.) So listing "FirstName" twice may cause problems. Instead, use an alias for one of them, and rename the form field:
select FirstName as [FirstName], FirstName as [AnotherFirstNameField]
from MyTable
|
|
Charlie Solomon
Beldin Technologies |
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.6
|
|
|
|
|