SSRS report definition is in XML (RDL) format. You can manipulate the RDL file programmatically at will to achieve your goals. Related article: How to pass parameters to SSRS report programmatically Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Okay so i need some advice. This might not even be SSRS possible. We need a report formatted like a single excel book(with multiple sheets) with relationship built in so we can modify one report and result in the others, i assume this is subreport based. The header would contain the company name, picture and specific information about a said "field". However the body would contain detailed information about the field. We can page break based on field in the table, sure easy. However how do we update the header/footer based on the information currently existing in the table in the body?

Hi boris37, Based on your information, I think you can store your company name, picture and specific information in database, since report header has relationship with report body content, you can type in expressions(eg. IIF or Switch) on the report header based on the report body content to show different content on the report header. For more information about expression in reporting services, please see: http://msdn.microsoft.com/en-us/library/ms157328.aspx Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.