Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Merge Cells by Formula?

Author  Topic  Pher Starting Member 1 Post Posted - 2011-01-20 : 15:39:47 I have a table where some of the records are data and some are headings. The database is not set up use groups, as the data are not related to the headings. There's a sort order field to make the data follow the correct heading, but the user can move things around through a web interface. What I want to do is to have the heading go all the way across the table, while the data will occupy 6 cells. (There's a field to identify a heading.) Is this possible? In other programs I would have a hidden field that would come to the front under certain conditions. Reporting Services doesn't seem to allow overlapping cells or tables. I also tried to have two data rows in my table, one with a single cell for headings, the other with multiple cells. I hoped I could use the Visibility property to show or hide the individual rows as necessary, but I couldn't get this to work. Any ideas would be greatly appreciated!