Print Page | Close Window

Suppressing Columns

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15719
Printed Date: 19 Apr 2025 at 12:57pm


Topic: Suppressing Columns
Posted By: Thara
Subject: Suppressing Columns
Date Posted: 27 Feb 2012 at 12:18am

In Crystal Report 2005,Is it possible to hide a column.I am able to able to suppress a field, and after suppression it is showing blank column. But how is it possible to hide the blank column.


Replies:
Posted By: lockwelle
Date Posted: 27 Feb 2012 at 4:11am
if you want your report to 'reclaim' the space used by the suppressed column, ie shift to cover the area...it can be complicated.  If it is only 1 column, life isn't too bad.
On the other hand, there isn't a Crystal 2005, are you referring to the version that came with VS2005? If so you might be out of luck....
 
Right click on a field, if there is an option 'Size and Position' then you can craft a 'formula' using the x-2 button to shift your columns left or right by an amount x. 
The caveat here is that the amount moved is in twips, which are 1440 to the inch.  So to move column to the left by 1 inch you would put in the (original location * 1440) - 1440 in an if statement so that it only moves if some condition is met.
 
You can have multiple fields suppressed but you will need to have a mechanism to account for which fields are how big and how to shift the fields around.
 
I have done this once for an entire report, but it was 5 years ago and I don't remember all the details.
 


Print Page | Close Window