What are the limitations around SSRS ?
Note: These are some known limitations in SSRS and depending on the complexity of the report there could be more.
Export outputs of the PDF and Word templates would not be identical as Word format has more limitations.
Cannot use conditional based page numbers in the report footer at the time of rendering the report into Word template. It supports only for PDF template.
Cannot repeat the table headers when moving to a new page in the Word templates.
Cannot repeat the grouping headings when moving to a new page in the Word templates.
Limitations in rendering the reports into Excel format such as handling multiple sheets and merged cell issues.
Unable to have Table of Contents with dynamic page numbering.
When showing data available in rich text boxes in SSRS reports there are few limitations as not all html mark-up tags are supported in SSRS.