Forum Moderators: open

Message Too Old, No Replies

Show Fields in Crystal Reports Only Which have 0

I am using crystal reports with 1 table

         

Kernel

7:11 pm on May 26, 2005 (gmt 0)

10+ Year Member



Hello Friends!
This is my first post!
I am building a project in which i want to show only those fields in Crystal Reports which have 0 Value.
I am using: -

1) Crystal Reports
2) One Table

We can use here a formula like:

SelectionFormula = "IIF{Fee.April}{Fee.August}{Fee.December}{Fee.February}{Fee.January}{Fee.July}{Fee.June}{Fee.March}{F ee.May}{Fee.November}{Fee.October}{Fee.September} = 0 Then "0" Else "Fee Paid"

But i don't know the correct syntax of this formula.
Please any brother can guide me.
I am looking for this formula or any other way to solve this

Thanks in advance.

Regards!
Kernel

tomasz

9:01 pm on May 26, 2005 (gmt 0)

10+ Year Member



in Crystal Report Designer rigth mouse click on field->Format Field->Suppress (Common Tab) and click X2 Formula Builder,

Kernel

7:55 am on May 27, 2005 (gmt 0)

10+ Year Member



Thank you very much for ur reply...

But i am talking about the syntex of the formula, this is not a correct forumula. I need a correct formula.

Please help!

tomasz

4:55 am on May 28, 2005 (gmt 0)

10+ Year Member



well,

if
{Fee.May}=0 or {Fee.June}=0 or ....
then "Not Paid"
else "Paid"

if any of those months is 0 then "Not Paid" else paid.

I do not know what you are trying to do