Solved

How to "hide" or "suppress" without disturbing formulas

Posted on 2014-11-11
9
240 Views
Last Modified: 2014-11-18
Gurus,
 
I'm trying to build a "summary only" report but to get my calculations I have subreports and detail info which I need to "hide" or "suppress".

The problem is when I "hide" or "suppress" those sections the formula values don't calculate.

Can you think of any way around this?  My client won't want to scroll through many pages to see the final values.

Thanks in advance!


Steve
0
Comment
Question by:SStroz
[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
  • 4
  • 3
  • 2
9 Comments
 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 40436249
Are the formulas calculating totals using variables?
If so simply change your formulas so they display nothing (empty string)

WhilePrintingRecords;
Global NumberVar MyTotal;
MyTotal := 0;
""

Open in new window


For subreports make sure they don't display anything
Remove the border around it (FORMAT SUBREPORT)

You can then suppress sections with the SUPPRESS BLANK SECTION option in the SECTION EXPERT

mlmcc
0
 
LVL 35

Accepted Solution

by:
James0628 earned 250 total points
ID: 40437035
FWIW, I've never noticed a problem with formulas if I suppress a section.  The formulas always seemed to be evaluated anyway.  But it might be different in different versions of CR.

 For the subreports, in addition to the things that mlmcc mentioned, go into "Format Subreport", select the Subreport tab, and select the "Suppress blank supreport" option.

 If you simply suppress a subreport, or the section that it's in, then the subreport won't be run.  But if you use the options that we mentioned, the subreport is run (and sets any variables), but it doesn't produce any output, so the blank subreport is suppressed, and if that's the only thing in the main report section, then the main report section is suppressed.

 James
0
 
LVL 7

Author Comment

by:SStroz
ID: 40439199
I'm using Crystal 2008.  This isn't looking good.  I tried removing some of the fields from the subreport and it's not working so I guess the answer is, yes, my variables are relying on those fields.  

An additional twist is I actually have two groups so if I have to show the subreports (even if they're reduced or small, or use white fonts, etc) I may have a lot of space before my totals.

Any other ideas?

Steve
0
Industry Leaders: 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!

 
LVL 101

Expert Comment

by:mlmcc
ID: 40439211
Can you upload the report file?

mlmcc
0
 
LVL 35

Expert Comment

by:James0628
ID: 40439532
Who said anything about removing fields from a subreport?
 Feel free to remove any fields that you don't actually need, but that really has nothing to do with "hiding" the subreport.

 Do the subreports produce any output (fields, etc.) that you actually need to see?  If not, start by simply suppressing every section in a subreport.  The subreport should still be run, and set the variables, but not produce any visible output.

 It will still occupy some space on the main report, but, as we described earlier, you can then go into the subreport format and check the "Suppress blank subreport" option.  Then the subreport won't be shown at all (but it will still be run).

 And if there is nothing else in the main report section that contains that subreport, check the "Suppress blank section" option for that section of the main report.  Then the section that contains that subreport should be suppressed, but the subreport will still be run.

 James
0
 
LVL 7

Author Comment

by:SStroz
ID: 40440960
Thanks for taking a look.  Go easy on me - I'm not a guru yet!   ; )


Steve
Marketing-ROI-Report-By-Year-for-EE.zip
0
 
LVL 35

Expert Comment

by:James0628
ID: 40441083
If you don't need to see the output from those subreports, did you try the things I suggested.  The subreports won't be shown at all, but you still get your totals.

 James
0
 
LVL 7

Author Closing Comment

by:SStroz
ID: 40450492
Mike & James,

Thanks for your patience here.  After digging in a little deeper your suggestions worked perfectly!

Thanks so much for your help here!!!


Steve
0
 
LVL 35

Expert Comment

by:James0628
ID: 40450775
You're welcome.  Glad I could help.

 James
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

717 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