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 |
|
mohit_3454
Starting Member
2 Posts |
 Posted - 2012-01-09 : 06:33:19
|
| Hi Everyone,I have a really frustrating problem that i have not been able to solve for quite some time now.Despite looking for a workaround on the internet i still havn't found anything that could work in this regard.May be someone can help me out with this here!!!!!The issue i have is very basic.I have a table that has a fixed number of columns (say 10), and i want to hide 3 of these columns at runtime based on the value of parameter which the user would select..This can be easily done by setting the coulmn visibility of each of these 3 columns based on the value of the aforesaid parameter...It's perfectly fine uptill here...The problem is when the report shows up (with 3 columns hidden) the remaining 7 columns take up the place of the hidden columns and as a result the overall width of the table reduces accordingly...I do not want this to happen..i.e. i want the table width to remain constant..That is to say the remaining colums' width should somehow be able to expand so that the original overall width of the table remains same...Is this possible to achieve....Please Help..I really need this to get going asap.Thanks In Advance... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-09 : 06:48:09
|
| did you try setting autogrow property to false for the columns in table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
mohit_3454
Starting Member
2 Posts |
Posted - 2012-01-09 : 22:55:28
|
I think you are pointing to the CanGrow property !!!I have tried setting that to true & false as well, but that didn't help either...Maybe there is no way of getting this done.... quote:
Originally posted by visakh16
did you try setting autogrow property to false for the columns in table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
|
|
|
Static table width while hiding columns