Mimic Excel "Hide Columns" in List view

[mickeyfinn]

FYI, this is my first post.

Is it possible (using sliding perhaps) to have columns and their labels hide when the value of their summary is 0? Or even a way for the user to select columns to hide? I have hidden fields by sliding left but I have not been able to stop resizing of fields since this will put the field out of alignment with other fields set as part of that column. It's also nice, though not essential, to use center alignment.

There may be some conditional formatting that does this but I can't find the correct option. Also, I thought about using the table view, but the one problem is that I need to label columns using rotated text-field labels (as the columns must be very narrow to fit enough of them onto a page). Ideally, I'd like for them to be 3 characters wide only. I made a script that would set these text field labels to "" if the total of each column was 0 to enable these to slide. Again, it does not seem possible to set the size of these correctly so as not to mess up vertical alignment.

I have searched previous threads but have not found a clear answer to this. I thought maybe Filemaker 9 may have an ability in this area I haven't come across. Apologies if this is a much-asked question.

Also, if there is something that will do this that is FM7 compatible, all the better since I use my server to share the database. Since I have v9, I could always print these reports for the user myself for the time being until we are able to upgrade...

Thanks in advance to any/all who reply.