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.
| Author |
Topic |
|
ftamminga
Starting Member
2 Posts |
 Posted - 2006-11-28 : 04:37:07
|
| Hi, I am constructing a report with the Report Designer in which I want to create a form of visual grouping by hiding duplicate data. My data is this: foo 2006-01-01 12 foo 2006-01-01 32 foo 2006-02-02 345 bar 2006-01-02 1534 bar 2006-03-03 345 bar 2006-03-03 234 And this is how I want it to be: (too bad I can't use html in this forum, just ignore the dots) foo | 2006-01-01 | 12 .... | ................ | 32 .... | 2006-02-02 | 345 bar | 2006-01-02 | 1534 .... | 2006-03-03 | 345 .... | ................ | 234 I can achieve the basics, only the grid renders all cell borders. So instead on 'foo' being one vertically merged cell, it shows two empty cells below it. How to do this? It should be something like merging cells vertically, but how to combine it with duplicate data? Or am I on the wrong track and should I do this with another technique? Thanks in advance,Frank |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-28 : 05:02:53
|
| I think there is a setting "Hide duplicate values" you can set.Peter LarssonHelsingborg, Sweden |
 |
|
|
ftamminga
Starting Member
2 Posts |
Posted - 2006-11-28 : 05:12:42
|
| Maybe I was not clear in my question. The situation I got is exactly what happenes when I use that option :) |
|
|
|
|
|
|
Vertically merge cells containing duplicate data