I have two questions, hoping someone can help:
I am retrieving data from SQl Server in a array. Prior, while fetching the data, I was printing this data onto a text file. Instead of printing to text file, I'd like to print to PDF. How can I do that? (I can print a line of text using the pdf::api2 module, but I am having difficulties printing from an array)
Now the second question is, the data returned has unique account numbers by summary level. I like these account numbers to be a hyperlinks on the pdf. So if user clicks on account number #12345 - I want to get that value (12345) and run a SP that will give me details about that accountnumber and then output the details onto another pdf page. Once again, I can create the hyperlinks using an annotation object for static text, but what about dynamic text?