I Have a field name flag(Number) in the main report.

I have two subreport next to each other in a single detail section. Based on the field value, if it is 0 the left side subreport should be visible or else it should be suppressed or invisible if it is 1. Kindly guide me writing the formula and in which section should i write it.

 

I have wrote the formula by clicking the left subreport--> Format Subreport--> next to suppress button clicked the formula button--> wrote the below formula

 

if{?flag}=0 then true;

 

but the above formula is not working,kindly help me..

 

Thnks...

 

Just trying to give u some suggestion. Not sure will work or not but u can try.

 

Steps:

1) Share your main report field value into left report.

2) Then drag the share formula into your left report header and try preview the left report and see whether the shared value is correct.

3) If yes, use that shared formula and do your suppress condition.

 

true =>> suppress the section

 

a simpler way, as the 'if' isn't needed is

 

{?flag} = 1

 

will suppress the object when the flag = 1.

 

HTH