I Need Help Displaying information...

[spachuca]

I am creating a report which is checking a box and displying address information by report ID. The moment report ID is duplicated more the once. check box id checked but address information is not dispalying.
thank you in advance..

 

[njahnavi]

if you check the checkbox then the address information of that particular reportid must be shown right...

if the reportid is duplicated it must be confused which adress to show ....with the minimum info given this is waht i can think of...throw some more information to help more...

 

[spachuca]

Report ID AgencyID Branch other
1908 1 Null
1908 2 1
1908 3 Null
1908 4 Null
1908 10 CITY of LA

In this senarion I get the check box which is AgencyID

IF {ReportingAgencyID} = 2 THEN
'X'
ELSE
' '

Evaluate the formula
{@AgencyID } <> ' '

then, I drag the fields from the Agency table such as Address, city zip etc.

But I get blank Adress.

I should be displaying the information from {ReportingAgencyID} = 2 check box

Branch = 1, Address, City, Zip, etc..

thank you..

 

[lbass]

Is the sample data you are showing at the detail level or at some group level?

Where did you put the formula:

{@AgencyID } <> ' '

Please show a sample of data at the detail level with the address displayed (before applying the formula).

-LB