Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Cross Tab Report- Suprressing unwanted columns Post Reply Post New Topic
Author Message
labscientist
Newbie
Newbie
Avatar

Joined: 19 Mar 2008
Location: United States
Online Status: Offline
Posts: 1
Quote labscientist Replybullet Topic: Cross Tab Report- Suprressing unwanted columns
    Posted: 19 Mar 2008 at 5:49am
I created a cross tab report to summarize laboratory data. Once the data is pulled there are some result columns that are not needed. Is there a formula or some way to suppress only certain columns so they do not print out on the report. Any help would be appreciated. Thanks.
Heather
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 19 Mar 2008 at 11:48am
You will have to build this into your record selection formula to filter out the data that you don't want printed. There is no way to disable columns from a cross-tab object.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
wislon32
Newbie
Newbie


Joined: 18 Apr 2008
Location: United Kingdom
Online Status: Offline
Posts: 4
Quote wislon32 Replybullet Posted: 20 Apr 2008 at 4:53am
Brian is quite right in saying there is no way to remove them.  I haven't found a way of suppressing the column as such.  Filtering removes the data which may give you incorrect totals.

However, it is possible to 'suppress' the data for the given column.  The column gap will still be there but the data will not appear. To do this:
1) Open the Cross tab expert.
2) Go to the Custom Styles tab
3) In the Columns box, select the column you are interested in
4) Below the Columns panel is a box labelled 'Alias For Formulas'. You MUST give this a name (not the field name) For example BoardingDate. Anything will do; this is the 'variable' name you will use in the suppression formula later
5) Close the expert
6) Select the Column Header in the cross tab design (or preview). Right Click and select 'Format Field...'
7) In the Common tab, click the Conditional Format button.
8) In the editor select from the Functions Tab 'Formatting Functions' and find CurrentFieldValue. Place this in the editor.  To Suppress for example 'Others' complete the statement with
CurrentFieldValue like 'Other*'
Save and Close
9) For each summary field that you have in that column, and the total,
a) select the summary field, Right Click, select Format Fields and the Suppress conditional editor button
b) Find GridRowColumnValue and place it in the editor.
c) locate the name you used as an alias from RowAndColumnNames and
 put it between the brackets and add the condition:

GridRowColumnValue ("BoardingDate") like 'Other*'
Check and close

And there is no way that I've found of individually setting the column width, change one they all change, but this may help.




IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.032 seconds.