Solved

Suppress Cross-Tab Summarized Field - Conditionally

Posted on 2012-04-04
16
1,022 Views
Last Modified: 2012-04-06
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
0
Comment
Question by:IO_Dork
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 6
  • 4
16 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 37808913
Try
    CurrentFieldValue < 5000

mlmcc
0
 
LVL 35

Expert Comment

by:James0628
ID: 37809580
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 37811618
I think it will work but it may suppress the full column

mlmcc
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:IO_Dork
ID: 37811865
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
 
LVL 35

Expert Comment

by:James0628
ID: 37813008
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
 

Author Comment

by:IO_Dork
ID: 37813904
CRXI
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 37814792
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
 

Author Comment

by:IO_Dork
ID: 37814813
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 37814833
Can you upload the rpt file?

mlmcc
0
 

Author Comment

by:IO_Dork
ID: 37814860
here's the file.
sample.rpt
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 37814885
Like this one?

mlmcc
sample.rpt
0
 

Author Comment

by:IO_Dork
ID: 37814899
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 37815054
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
 
LVL 35

Expert Comment

by:James0628
ID: 37815098
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
 

Author Comment

by:IO_Dork
ID: 37815948
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
 
LVL 35

Expert Comment

by:James0628
ID: 37818382
No problem.

 James
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crystal reports - Formula Field code need assistance with code 17 92
Selection between two dates and time range. 21 47
Crystal Reports Version 7 4 39
Crystal Reports 2013 25 60
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question