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

Avatar

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



Example:



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

----------------

CREATE PROCEDURE GetClient

@id int

AS

SELECT LastName, Location FROM Clients WHERE ID = @id

GO



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

Avatar

Not applicable
Anyone every figure out how to do this?

Avatar

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

You can find more info. in IACReference.pdf

ulf.a@dtp-tjanst.se

Avatar

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.



Thanks



Ernest