Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Generate Report from SQL Query with Parameter


Not applicable
I have a web application that needs to generate static PDF reports. What I want to do is:

1. Use Acrobat to create a form

2. Open the form programmatically on the webserver

3. Pass it a parameter such as a "clientID"

4. Automatically populate the rest of the form using a SQL stored procedure with the clientID as the parameter

5. Save the form as a static, non-editable PDF and display it for the client to either view/save/print


Database would contain a table called Clients


ID LastName Location Phone

1 Doe New York 111-111-1111

2 Smith California 222-222-2222

Stored Procedure



@id int


SELECT LastName, Location FROM Clients WHERE ID = @id


Acrobat Form


Last Name: [txtLastName]

Location: [txtLocation]

Website user requests report for clientID=1. Result is a PDF that looks like this:

Last Name: Doe

Location: New York

I am very new to Acrobat, so please explain in detail how I can go about doing this. Thanks very much in advance.
3 Replies


Not applicable
Anyone every figure out how to do this?


Not applicable
You can do this in a MS Access application and Acrobat API.

You can find more info. in IACReference.pdf


Not applicable
Good morning. Did you find a solution to your problem? I'm looking for something to do the same for a from created in Live Cycle 7.0. If you can share some information or examples, I would greatly appreciate it.