Share via

can a footer show data being used on the current page's tablix

db042190 1,516 Reputation points
2020-08-23T17:00:06.84+00:00

hi we run 2016 enterprise and develop in vs 2017.

can a footer's text boxes "see" data from the single row currently feeding the tablix which just runs a subreport? the subreport is run once per page of the master report. the footer would be added to the master report. i suppose it will somehow have to be mapped to a parameter first. so amybe the question is really "can a parameter be reset on each row of a tablix's dataset"? currently i have a rectangle at the bottomof the subreport but i am faking blank lines in the subreport trying to push the rectangle t the bottom of the subreport. unfortunately while i'm coming close , there is no consistency in where the rectangle shows from page to page.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,860 questions
0 comments
Accepted answer
  1. Joyzhao-MSFT 15,571 Reputation points
    2020-08-24T02:35:18.747+00:00

    Hi,
    No, a footer cannot show data being used on the current page's tablix.

    And Report Parameter cannot reset itself on each row, unless you are talking about other parameter not the report parameter which is chosen before report rendering.
    Regards,
    Joy

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. db042190 1,516 Reputation points
    2020-08-23T19:44:22.413+00:00

    i tried giving the bottom rectangle a top location that was more commensurate with where it is supposed to end up after the tablix's expand from data. That didnt seem to work.

    0 comments
  2. db042190 1,516 Reputation points
    2020-08-24T14:41:54.353+00:00

    yes, other params (probably hidden) that would be used just for this feature. is that possible?