report

lazziegal

I want to hide some of the columns in report based on different requirement, what should I do?
The requirement is determine from one of the field n different table.

Please guide me.

Thanks in advanced.

einsTeIn.NET

Create two (or more) sections. One with your columns and one without your columns. Then use CurrReport.SHOWOUTPUT to suppress printing of the sections depending on your conditions.

lazziegal

Thanks a lot!!

David_Singleton

Or you can just over lay the controls and make them visible or not by controlling what is in the control. Generally einstein's approach works well if you have two or three different formats and its the most common way. This way I describe is better if you need to give the user the option to display or not display a particular column. maybe for security or to avoid clutter.