interactive report in apex linking to pdf
I am building an interactive report based on a view from my oracle table. I want to use the single row view icon to display pdf reports which already exists on my web server. For example, if the id of my row is xxx, then pdf filename would be xxx.pdf.
how can i direct it to the right pdf based on the interactive report????
Also how can i restrict the security of the pdf's for only those who browse through the apex???
Thanks