Open a workbook through role

Hi Guys,

I was wondering if someone can tell me if it were possible to open a workbook from a hyperlink in the role.

Ok, let me try to explain this better. As of now, all the reports that had been developed at my client were done using a single query. When this query is assigned to a role, the user can see the hyperlink (on his/her page)to the report which is diplayed in the web. I wanted to know if that can be done for a workbook, when I assign the workbook to a role? If so how can is the workbook displayed?

Appreciate your expert advice.

Doniv