Problems with Page Headers
Allrighty, this is my first in a line of entries relating back to problems we have experienced using page headers and the workarounds we have implemented to get our reports running. For any who are unfamiliar with what I am talking about please see pic:
So, here's the problem. Essentially for whatever reason you aren't able to place fields returned in the dataset into this Page Header area...... WHY? I don't know but it sucks big time, in every other reporting tool I have used this isn't an issue and most often in the reports I have been working on it is necessary to place data as it is returned from the database into this header information.
The Workaround
ok so here comes the ugly part, to workaround this what we ended up doing was to add an additional detail line to the report, make the cells (this is important) invisible and shrink the row size down to really small. Then reference the textboxes that are in the detail line from the header. This works....
Note: you can't make the entire row invisible as SSRS will deem that there is no data in it and you fields in the heading will show up blank..... stupid huh???
posted by Thomo @ 10:25 AM
0 Comments:
Post a Comment
<< Home