Report Design: how to Suppress blank field?

Print Page | Close Window

how to Suppress blank field?

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=935
Printed Date: 02 May 2025 at 12:08pm

Topic: how to Suppress blank field?

Posted By: ericooi1976
Subject: how to Suppress blank field?
Date Posted: 27 Jun 2007 at 5:08am

Dear all master,

I trying to suppress a blank field, it just can't work. anyone can help.

Im using the crystal report in Visual Studio 2003.

here i give some example that i want:

Name Age telno

abc 12 1234567

def 9999999

ghi 25 9876543

you can see the age for name "def" is empty.

FYI, each of the data is individual field.

How can i suppress it, so that the age 25 will move up to "def"?

Thanks a lot

Regards,

Eric

Replies:

Posted By: BrianBischof
Date Posted: 27 Jun 2007 at 8:59am

Go to the Section Expert dialog box and find the Suppress property on the right. Click on the Formula button and set a formula similar to

[table.Age] = "";

This will suppress the record when the age is blank.
You could also set the record selection formula so that it says [table.Age]<> "".

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: ericooi1976
Date Posted: 27 Jun 2007 at 6:50pm

Thanks for prompt reply.

I tried that way, but seem it not work for my case, because the all the field is individual.

abc (field "name1") 11 (Age field "age1")

def (field "name2") 22 (Age field "age2")

ghi (field "name3") 11 (Age field "age3")

please help...Thanks

Posted By: BrianBischof
Date Posted: 27 Jun 2007 at 8:29pm

Really? That's interesting. I thought that your original example was three rows of record with each row being one Detail that was repeated. Now it appears that this whole example is on detail section with NINE fields in it. Actually, now that I read your post again I see that you mentioned that (I missed it).

Ok, I threw this formula together and it seems to work pretty well. It isn't very efficient (unless you make the AllAges variable Global so it doesn't have to be recalculated each time), but it's not a big deal.

Create this formula for each time you want to display the age and change the final array subscript for each formula from 1 to 2 to 3 so that it displays each index once. Also, put the full age field name in the formula.

StringVar AllAges;
AllAges := IIF({Age1}<>"", {Age1}+",","") & IIF({Age2}<>"", {Age2}+",","") & IIF({Age3}<>"", {Age3}+",","") & ",,,";
Split(AllAges,",")[1];

Real quick, this formula builds a comma separated string of all the non-blank age fields. If a field is blank then it doesn't get added. AFterwards, the string is split into an array and you just display one element of the array.

This should work for you!

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: ericooi1976
Date Posted: 29 Jun 2007 at 4:23am

Thanks it's help a lot

Posted By: BrianBischof
Date Posted: 29 Jun 2007 at 10:31am

Glad to! A link is always appreciated.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Print Page | Close Window