Avatar of SStroz
SStrozFlag for United States of America

asked on 

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
DB Reporting ToolsCrystal Reports

Avatar of undefined
Last Comment
James0628
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of James0628
James0628

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of SStroz
SStroz
Flag of United States of America image

ASKER

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
Avatar of Mike McCracken
Mike McCracken

Can you upload the report file?

mlmcc
Avatar of James0628
James0628

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
Avatar of SStroz
SStroz
Flag of United States of America image

ASKER

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


Steve
Marketing-ROI-Report-By-Year-for-EE.zip
Avatar of James0628
James0628

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
Avatar of SStroz
SStroz
Flag of United States of America image

ASKER

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
Avatar of James0628
James0628

You're welcome.  Glad I could help.

 James
Crystal Reports
Crystal Reports

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo