[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4475
  • Last Modified:

Supress cross tab column conditionally

hi,

i have a crosstab where i need to suppress a column for display only.
i will still need the data of that column for calculations but i want to hide it under a certain condition.
i tried suppressing the fields in the crosstab and the use 'supress empty columns' in crosstab options.

any ideas?

thanks
CM
0
carlosmonte
Asked:
carlosmonte
  • 3
  • 3
  • 2
  • +1
3 Solutions
 
PCIIainCommented:
Which calculations?

What you could do is to create a formula for the value  something like

if( - column should not be suppressed - )then
  {datafield}

which will return the data only if the column should not be suppressed, and then suppress empty columns. But that data will not then be included in the totals columns for the crosstab.
0
 
wykabryanCommented:
try this.. you may need to play around with it but the use of GridRowColumnValue.
in design mode, right click on the summarized field in the crosstab. Then click on the general tab and suppress. Use the above function GridRowColumnValue ({tablefield}='the name of the column'. Do the same thing for the column heading.
0
 
PCIIainCommented:
I think that relies on crystal 2008, and the tags for the problem say crystal XI.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
wykabryanCommented:
GridRowColumnValue was introduced in Crystal 9.. It will work in all future versions. I currently use it in CR10.
0
 
PCIIainCommented:
Cool, learn something new every day...
0
 
mlmccCommented:
Can you give a simple example of what you are trying to suppress in the cross tab?

How do you determine the column needs to to be suppressed?

mlmcc
0
 
carlosmonteAuthor Commented:
hi all, thanks fo rthe replies
I was looking for a way to just suppress an entire column in the crosstab depending on the value of the column header value in my case a date. there isnt i assume

PCIIain solutions  appears to be the correct one.
If i suppress using gridcolumnvalue i can suppress the summarized field in the crosstab, header or anything i want. now my column is blank (no fields displayed in the column i wanted) but does not suppress the column itself. apparently it does not recognize the column as empty and thus the 'suppress empty columns' does not work.


guys agree?
0
 
wykabryanCommented:
The gridcolumnvalue that i suggested will suppress the value. The crosstab still reads in the data so it created the column for it. I am not sure if there is a way around that.
0
 
mlmccCommented:
GridRowColumnValue  can only be used in formatting formulas.  It can't be used in suppression.

I suspect there is no easy way to accomplish what you want.

mlmcc
0
 
carlosmonteAuthor Commented:
PCIIain solutions  works great in my report.

thanks for all the input
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now