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

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
LVL 7
SStrozAsked:
Who is Participating?
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:
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
James0628Commented:
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

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
SStrozAuthor Commented:
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

mlmccCommented:
Can you upload the report file?

mlmcc
0
James0628Commented:
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
SStrozAuthor Commented:
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
James0628Commented:
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
SStrozAuthor Commented:
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
James0628Commented:
You're welcome.  Glad I could help.

 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
DB Reporting Tools

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.