Josen, Your link would hit an action page that would pull up the report. One thing I would strongly recommend. Have your link open a new window. Depending on the browser it can/will get stuck in the pdf. A huge annoyance. Here is a quick example of how the action page works...Hope it helps <!---Sets up a random number so each pdf will have it's own unique name at the end. If data doesn't change/you delete them immediately you don't need to do this. ---> <cfset Rnum=#randrange(100000,999999)#> <!---Create toolkit com---> <CFOBJECT ACTION="Create" TYPE="COM" CLASS=APToolkit.Object NAME="Tlkt"> <CFOUTPUT> <!---Name of "finished/merged" pdf- can be whatever you want- mine ends with the random number---> <CFSET R = Tlkt.OpenOutputFile(ExpandPath("../PDFForms/Schools#Rnum#.PDF"))> </CFOUTPUT> <!---PDF Template that is made/used. All boxes on this pdf have been coded to coincide with my query output---> <CFSET R=Tlkt.OpenInputFile(ExpandPath("../PDFs/SchoolsPDFTemplate.PDF"))>
<!---Setting up query output to go to pdf---> <CFOUTPUT QUERY= "SchoolData"> <CFSET SCHNAME=Tlkt.SetFormFieldData("SCHNAME","#SchoolData.NAME#", 0)> <CFSET PRINCIPAL=Tlkt.SetFormFieldData("PRINCIPAL", "#SchoolData.PRINCIPAL#", 0)> <CFSET SchADD=Tlkt.SetFormFieldData("SchADD","#SchoolData.ADDRESS#", 0)> <CFSET SchCIT=Tlkt.SetFormFieldData("SchCIT","#SchoolData.SchCIT#", 0)> </CFOUTPUT> <!---Close up the forms/reset fields for next time---> <CFSET R=Tlkt.CopyForm(0,0)> <CFSET R=Tlkt.ResetFormFields()> <CFSET R=Tlkt.CloseOutputFile()> <CFSET Tlkt=""> <!---Open actual pdf for user Note this is same as the OpenOutputFile name, except has the complete location. I use a request.pdf because I don't want the address hardcoded ---> <CFOUTPUT> <META HTTP-EQUIV="Refresh" CONTENT="0; URL=#Request.PDF#PDFForms/Schools#Rnum#.PDF"> </CFOUTPUT> -----Original Message----- From: Josen Ruiseco [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 9:05 AM To: CF-Talk Subject: Active PDF? I just purchased active Pdf and am having a rpoblem figuring out how to merge pdf docs together. I have contacted support and after three days they still have not helped me. Basically I have document names stored in a database. I want to pull those names and merge, then show a link to the merged document where the user can view it. Can someone post some code demonstrating this? Thanks, Josen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4