Column value to be displayed on the header

Asked Nov 22 '16 at 16:49

Active Nov 22 '16 at 18:19

Viewed 27 times

I am doing a report using SSRS-2008R2.I have done all the work and table.I have column("Dept").It is done group by and so that the output has each Dept values in a separate page.I also need to keep the Dept value in the header.How to keep it to the header??.When I tried to directly drag the column from dataset to the header it shows the first value of Dept to all the pages.help me with that

Ex: enter image description here

enter image description here

So, in the second image the header should have the Dept value of A0110 but it is showing the same value of 1st one's(A0100)

edited Nov 22 '16 at 18:19

asked Nov 22 '16 at 16:49

Krish Dev

Did you add a parent group for Dept? If so, then you should have added the Header row for that. – SS_DBA Nov 22 '16 at 16:54
It seems you need to create a [column group](http://www.tutorialgateway.org/grouping-in-ssrs-matrix-reports) – alejandro zuleta Nov 22 '16 at 16:56
Updated the question with image.please check that and give solution – Krish Dev Nov 22 '16 at 18:21
What is the expression of that textbox? Specify the Group in the scope – SS_DBA Nov 22 '16 at 18:39

Column value to be displayed on the header

0 Answers0