Click here to Skip to main content
15,891,431 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am developing a crystal report.
Report contains 5 fields in a section.
If first 2 fields are suppressed, then Third field has to be suppressed.
how to write formula for that? Please Help me

ex:
section 1:
__________________________________________________
field1 field2 field3 field4 field5

__________________________________________________
Section 2:
___________________________________________________
field1 field2 field3 field4 field5
___________________________________________________

In Each section if first two fields are suppressed then suppress the third field
Posted
Comments
Vedangi 10-Jul-12 4:32am    
You can create put same conditions on field3 which is on field1 and field2 , if they are true , then supress field3.

Following article should help for Conditional Formatting: Conditional Formatting in Crystal Reports[^]

Try!
 
Share this answer
 
Comments
tony cox 16-Jul-12 12:11pm    
Thanks Sandeep for your timely help
The link you have given was really useful and informative
I think the above solution doesnt get you anywhere.

I want to know something.

is the field that is suppressed conditionally or manually suppressed?

If it is conditionally suppressed, then you can go into the conditional suppression formula of the field and include a variable that is set to 1 when suppressed and 0 otherwise.

You can then use this variable in field3 and see if the field is suppressed by checking if the variable returns 1 or 0.

Let me know if you succeed.

Thanks
Shaikh
 
Share this answer
 
v2
Comments
tony cox 16-Jul-12 12:10pm    
Thanks Shikhm. I apologise for late reply.
As you expected the field is suppressed conditionally.
I followed your Idea and got result. Thanks a lot

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900