Solved

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

Posted on 2014-11-11
9
233 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
  • 4
  • 3
  • 2
9 Comments
 
LVL 100

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 34

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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 100

Expert Comment

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

mlmcc
0
 
LVL 34

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 34

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 34

Expert Comment

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

 James
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

786 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