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 |
sunny9
Starting Member
4 Posts |
Posted - 2008-04-01 : 21:52:19
|
I am working with a report which contains 4 resultsets and 1st resultset should contain 10 columns and 2 should contain 8 and 3rd should contain 6 etc , i tried to write nested iif and hide the columns but the hidden coulumn leaves a blank white space and the table looks splitted ..How can i solve this Pls let me know..Thanks in advance |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-02 : 04:39:47
|
I also had this problem once and couldnt fix it. At least i made a work around. I created three tables one for each resultset and conditionally manipulated the hidden property of them so that based on result returned (10 rows/8 rows/6 rows,..)it will show only the corresponding table and hide all others. |
|
|
|
|
|