Exporting RDLC report to PDF programatically with hyperlinks to a file in a relative path

Question

I am working on a API where the response of an API is zip file containing PDF reports for a User. Along with all the reports that a particular user has, there will be one extra report called User Summary report, which will indicate the overall performance of a User. The summary report is designed using RDLC and is exported to PDF programmatically without using the report server. In the summary report we have a table where we want to have links to other PDF files in the ZIP. We are having some trouble in setting up the hyperlink in the table rows to point to a file in a relative path. Please suggest the way to set up Action on text box to open a file in a relative path.

Answer 1

Hi @Avinash Rao
You mean you create the summary report programmatically? I think it is impossible.

"zip file" ,does it mean that you compress the report ? and where do you locate the zip ,in the users computer ? like "c:\" ?
Here is a discussion about how to open file in a report :https://www.sqlservercentral.com/forums/topic/ssrs-open-file-instead-of-url-within-a-report

And related to how to export the report programatically ,please refer to :https://www.aspsnippets.com/Articles/Export-RDLC-Report-to-PDF-programmatically-in-ASPNet.aspx

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.