Suppress Cross-Tab Summarized Field - Conditionally

Can someone guide me on how to suppress the summarized field in a Cross-Tab when certain conditions exist.  I want to be able to suppress the summarized field if it is <5000. See attached screenshot for details.  I know how to add a suppress formula in the X-2 suppress button, but not sure if it applies to the summarized field in cross-tab...i tried the following but it did not work:

sum({trade.combasis})<4999
Experts-Exchange---All-values-le.pdf
IO_DorkAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Try
    CurrentFieldValue < 5000

mlmcc
0
James0628Commented:
FWIW, one problem with trying to use Sum ({trade.combasis}) is that that will give you the total for the whole report, which is probably not what you're trying to suppress in the cross-tab.  And I don't think a group summary would be connected to the groups (rows or columns) in the cross-tab.  Hopefully CurrentFieldValue, as mlmcc suggested, will work for you.  I'm not 100% sure because cross-tab's can be "difficult" at times.

 James
0
mlmccCommented:
I think it will work but it may suppress the full column

mlmcc
0
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

IO_DorkAuthor Commented:
yes, unfortunately it suppressed all the data since its looking at the per record level {trade.combasis} not the sum of the field - sum({trade.combasis})

any other suggestions.
0
James0628Commented:
I thought CurrentFieldValue would be looking at the value (summary) in each cell in the cross-tab, but maybe not.

 Which version of CR are you using?  I've only used CR 10, but I think CR 2008 added some new options to cross-tabs and there may be something there that will help.

 James
0
IO_DorkAuthor Commented:
CRXI
0
mlmccCommented:
I use CR XI.  It seems to work for me.

Are you looking to suppress just 1 cell or all total cells that meet the criteria?

mlmcc
0
IO_DorkAuthor Commented:
All/any cell that meets the criteria, for example, if user 1 total for a given day is less than 5000, then suppress the total for that day.  Evaluate each user total for each day separately.

See attached sample above, all cells highlighted in yellow show be hidden or blank, as long as it show nothing but blank space in those cells.
0
mlmccCommented:
Can you upload the rpt file?

mlmcc
0
IO_DorkAuthor Commented:
here's the file.
sample.rpt
0
mlmccCommented:
Like this one?

mlmcc
sample.rpt
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
IO_DorkAuthor Commented:
Exactly!

I did not realize when you said "currentfieldvalue < 5000" you literally meant "currentfieldvalue".  I thought that was a generic reference to the actually field I was using.

Thankyou!!!
0
mlmccCommented:
THat is a shortcut way of referring to the field or object value.

It even works with other database fields on the report.

mlmcc
0
James0628Commented:
Oh good.  I thought CurrentFieldValue should work, but things don't always work the way you'd expect/hope in cross-tabs (and I wasn't in a position where I could easily run a cross-tab report to check it myself).

 CurrentFieldValue can be used in the formatting formulas for any field on a report.  It can be particularly handy if you want to apply the same formatting formula to a number of fields.  You can create a generic formula using CurrentFieldValue, instead of specific field names, and enter that formula for all of the fields at the same time, or copy it from one field format and paste it into another.

 James
0
IO_DorkAuthor Commented:
James:

Thats good to know as most of my reports have a ton of formula fields that need to behave in a similar fashion, like the suppress function across all cells for each row.

Thanks,
Brian
0
James0628Commented:
No problem.

 James
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.