When your SSRS report produce more than one page of output then at the second page and onward you are missing the column headers. So you miss the mapping between data and corresponding column header. You may feel lost, but; how to survive from this situation? Must need to add column header in each page.
To achieve above you need to change some properties of the report. If you go to Tablix properties then you will find options to choose which work fine with matrix but unfortunately doesn't work with table.
To achieve above you need to change some properties of the report. If you go to Tablix properties then you will find options to choose which work fine with matrix but unfortunately doesn't work with table.
Fig 1: Tablix property |
Since in my
report, I have used Table (fig 2), so when I have used the above properties
from Tablix it did not work.
Fig 2: SSRS toolbox 'Table' |
To make it
work, I had to choose advance properties which are followings:
1) Make
advance property available
Select
heading section and then select the arrow at the right corner to get advance
option available (fig 3)
Fig 3: Finding advance property |
2) Update
the advance property value
After you
click the 'advanced mode' described in step 1, you will find below:
Fig 4: Looking into Advance mode |
No comments:
Post a Comment