We dont want to show some columns on the report based on user input. We are doing this by suppressing the columns based on the condition, but it creates a blank column space on the report. How do I get rid of that blank space at run time ?

Even while exporting to Excel (in data only mode), it does not delete that blank column space.

well I did this by a long method,I'll give u a hint...try to work on the width and left of the field,put the width of the column u want to hide =0 and try to decale all the field beside it by the left...u have tu use a SortedList where u put the columns...and u haveto use this syntax
SortedList.Add(RepDoc.ReportDefinition.ReportObjec ts(i).Left, RepDoc.ReportDefinition.ReportObjects(i).Name)
and
CType(RepDoc.ReportDefinition.ReportObjects(Column Hide,CrystalDecisions.CrystalReports.Engine.TextOb ject).Width= 0


nagham