Show Fields in Reports Only Which have 0

Hello Friends!
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


Also attaching my Project so that i got a perfect answer.


Regards!

I would create a formula, instead of using the field. then:

If {fieldname} = 0 then "0" else " "

I have so many columns like
January, February, March... December
In this case what u will do?

We can use here a formula like:

Quote:

---

SelectionFormula = "IIF{Fee.April}{Fee.August}{Fee.December}{Fee.February}{Fee.January}{Fee.July}{Fee.June}{Fee.March}{ Fee.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

hope this will help

Yes brother,
Thank you very much for help :)
But please tell me how you did this?


Thanks in Advance
Waiting for ur reply.

Kernel!

open my report then under main menu, goto report then select expert

I think u did not see my Crystal Report File...
I tried what u say, but still have some problems
My Table has 12 coloums in which program must have to check value 0 from these 12 coloums.
If i put 0 value in 12 coloumns then program show me the result in report, other wise blank. I want that if just a single coloumn have 0 value then the complete 12 columns show me the record.

the problem is i can not open your report, post your report and the database connecting to it, just the report and the database, not the whole project

Here i am attaching my database and report...

I want if only one Field e.g. "March" have '0' Then the whole row show. If any row don't have '0' value then Now show.


Thanks for helping.

Kernel

Any Sugession " kulitag " ?

Waiting for ur reply.

Any Sugession " kulitag " ?

Waiting for ur reply.

can't really understand but i really try though