October 18, 2018 at 6:25 pm
Hi,
I have a purchase order report that has an image in the header which is retrieved from the database. Depending on a specific field then the image that is sent to the report in the query can be different. If I run the the report of one document (call it PO123) I get the first image correctly. Then I run the report for a second document (call it PO456) I get the second image correctly. My issue comes that when I run the report to print both PO123 and PO456 at the same time then the image is fetched for the first document and then the same image is used for each subsequent document (split by page breaks). All the other data that changes in the header (address info in textboxes) update correctly on each page but the image remains the same.
Does anyone know how to force an image in the header to re-render with the new data for each page?
Thanks for any help.
Regards,
Neil
October 23, 2018 at 7:44 am
neil.weirsmith+SQLSC - Thursday, October 18, 2018 6:25 PMHi,I have a purchase order report that has an image in the header which is retrieved from the database. Depending on a specific field then the image that is sent to the report in the query can be different. If I run the the report of one document (call it PO123) I get the first image correctly. Then I run the report for a second document (call it PO456) I get the second image correctly. My issue comes that when I run the report to print both PO123 and PO456 at the same time then the image is fetched for the first document and then the same image is used for each subsequent document (split by page breaks). All the other data that changes in the header (address info in textboxes) update correctly on each page but the image remains the same.
Does anyone know how to force an image in the header to re-render with the new data for each page?
Thanks for any help.
Regards,
Neil
First, whatever link you have would have to be in some way dynamic, meaning that that link itself would have to be different for each and every row that is used to render the rest of the page (I am assuming that is always just one row).
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
November 5, 2018 at 1:43 pm
Since you are using page breaks, do you really need an official header? You can create something that looks like a header before each page break... either in your table, matrix, or list... without actually putting it the Header.
November 5, 2018 at 2:55 pm
Hi All,
Ok, so after a whole bunch of testing and trying of different things. Turns out the issue is actually just related to the fact that the one client is running an older version of SSRS. This however is an embedded application inside their existing ERP. This means that we can't upgrade it without upgrading the ERP.
So, for now, they will just have to live with the issue until such time as they are ready to upgrade.
PS: thanks for the replies.
November 13, 2018 at 7:03 am
Come to think of it, I doubt it's the version of SSRS. If you put an image in a header, it's not going to change until the group the header is associated with changes value. You either need a detail row to contain that picture, or you need to group by the object that needs it's picture in the report. Page break is irrelevant.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply