blank rows

Posted on 2011-04-27
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.
Question by:mcse2007
    LVL 18

    Expert Comment

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

    the suppress formula would be something like this:
    {fieldname} = ""
    LVL 100

    Expert Comment

    LVL 7

    Author Comment

    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.
    LVL 100

    Accepted Solution

    You don't modify the formula, but if it is blank you can use the SUPPRESS BLANK SECTION in the Section Expert.

    LVL 7

    Author Closing Comment

    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

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now