Hello,
hopefully this makes sense, but i am a little familiar using SSRS function code to grab build in variables like date or page number and use them from header to body, BUT, now i want to be able to use something that is from the body, into the header... but not sure how to do that in the function, below is the url link that i used to get global variable like page number into the body of the SSRS, but not sure how to do that going from body to header, any ideas?
https://stackoverflow.com/questions/4758793/access-page-number-in-report-body-in-ssrs
May 13, 2021 at 11:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
I have a report where I use values from a dataset in the header. I just use an expression rather than code at the report level to access the data.
I have a dataset named TopOfPage which returns one row of data though it could return multiple rows because I am just going to reference the first row.
I have a textbox in the page header with the following expression:
=First(Fields!OrderNumber.Value, "TopOfPage")
Another scenario could be if you have a textbox in the body, let's call it Textbox1. You could reference that through an expression in the page header.
=ReportItems!Textbox1.Value
I don't know if either of those will help you out. If not, maybe you could provide more information about what type of object/data you are trying to access in the body to display in the header. If you are unfamiliar with expressions, I could reply with more information about expressions.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply