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 |
|
Dan Tim
Starting Member
1 Post |
 Posted - 2009-07-14 : 04:06:34
|
| Hi,I have a table that is expected to have two headers as follows:ID Name Number 2 Dan 25Counry Location US 30 UK 35The 2nd header should be toggled by the ID data text box (not the ID header text box)The problem I am facing is that i the 2nd header repeats it self for each line instead of appearing only once |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-14 : 04:27:31
|
| I think your biggest issue is understanding what a table is. I think you have got confused between a table and a query.http://en.wikipedia.org/wiki/Microsoft_SQL_Server#ArchitectureAs far as your request goes, I will say this a presentation issue for you query output and should be dealt with at the front end (whichever front end app you are using). |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-14 : 13:43:47
|
| He's telling about report designer table. You can get the required format bu having two levels of grouping in table and in first level you give headers as ID, Name, Number and second level Counry, Location. then set toggle visibility based on another report item property for second level and give item as first item name. |
|
|
|
|
|
|
Sub Header in a table