We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

blank rows

mcse2007
mcse2007 asked
on
Medium Priority
453 Views
Last Modified: 2012-05-11
Hi CR experts,

I have some formulas in group footer (GF), when the result is not satisfied, the value is blank as seen from the enclsed file. When I export this report into Excel, it creates blank rows as seen from the enclosed file.

how do I format my formulas in GF so that if they are blank they wont get exported avoiding creating a blank rows?

appreciate your help in advance.
rows.bmp
Comment
Watch Question

Conditionally suppress the blank rows by setting a formula on your group footer 1 section.

the suppress formula would be something like this:
{fieldname} = ""
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:

Author

Commented:
here one of the formula inside the GF1

if {Sheet1_.ZFR1 - Airbag} <= 0 then "" 
else ToText({@airbag_placeholder})

How do I modify the above formula to supress the blank row?

@mlcc, thanks for the link, will take a look at it.
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Hey Mlmcc,

Have you ever thought about rewriting CR and name it differently and sell for a quick buck in the market?

You're dam too good...that did the trick....I've supressed them all, exported the report using Customer (format) Customer (Width) option only...bare minimum and it worked.

Why you didn't tell me this before? Just kidding.

Thanks mate
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.