I have a SSRS 2005 report using a table to display data. I am using a parameter to change visibility of the first column depending upon the sort selected, so I am also using group headings to display the column headings (instead of a page heading)
so that the column headings line up properly whether the first column is displayed or not. The group heading lines are marked to repeat, and one contains a dataset field as heading information. The table has multiple detail lines defined,
and the last line contains a text field (memo field) which can contain LOTS of data. If this field contains enough data that it takes an entire report page, the group heading is not displayed on this page, so all the column headings are gone for this
page. That is my problem.
There is a lot going on in this report, and the design, as it stands now, accomplishes all I need (dataset field in heading, optional column display with headings, proper sorting and breaking) with the exception of when this text field fills an entire
page...in this case, the headings disappear.
Any thoughts on getting around this? Thanks!
View Complete Post