Skip to Content
0
Former Member
Apr 22, 2009 at 02:45 PM

Supress a Details Section based on the value of a database field in report

22 Views

Hello all. I have seen posts that are similiar to what I am asking, but none of them have really worked. Here is what I have. I have four details sections. One needs to always appear, but the other three don't always need to show up. They only need to show up if a certain field in the database is a certain value. All three sections have different fields that are used to suppress.

Here is the formula I wrote in the suppress section of each of the detail field. (The field name changes with each one)

if = '153' then False

else true

Everything but the field name stays the same. This particular data is stored in three different fields. Each one needs it's own section. In any case the issue is the top field works fine. The data suppresses if it doesn't meet the criteria perfectly fine. The two below it don't work. They suppress no matter what. I did a query in our database to make sure the data is in the same format in each field and it is. There should be no reason the top one works and the others don't. Anyone have any thoughts on why this would happen. I don't have suppress blank section checked, figured the formula would handle it instead. I thank anyone for any help they can give me.

Interesting note on this. If the first details section is suppressed, it seems to suppress the rest of the details sections. Does this mean anything?

Jami

Edited by: Jami Benson on Apr 22, 2009 10:12 AM