Suppressing and Hiding Blank Field

[mpvel]

I have a Sales report which shows sales information for 10 weeks. I have few total and sell through calculated columns after 10 week columns.
I want to suppress, Hide the next 9 weekly columns if we have data only for 1st week. I could do that by using a formula with ISNULL on the 9 fields in details section. My additional requirement is to dynamically move the total columns to the right of the first week column. I noticed in one thread talking about this situation like, create a formula on whole details section. But I really did't get it.
Please share your ideas if you come across with this kind of situation.

Thanks in Advance.
MPVEL

 

[Madawc]

Sounds like you're wanting a Crosstab, which does those things automatically. Check under [Insert] on the menu and see if it meets your needs.

Madawc Williams (East Anglia, UK)