Show or hide data in a report based on certain criteria or condition

[Ed Dobbin]

I have a query with some of the following fields
BuildingNumber
Building Name
Sub-BuildingNumber
Bub-BuildingName
Location
TotalArea
Building Replacement Cost
DeptNumber
I was wondering if I generate a report that would hide
Sub-BuildingName if Sub-buildingNumber =0?
I would also like to Hide BuildingName if Sub-
BuildingNumber Is not =0.
Any help would be greatly appreciated.
Ed

 

[fredg]

I have a query with some of the following fields
BuildingNumber
Building Name
Sub-BuildingNumber
Bub-BuildingName
Location
TotalArea
Building Replacement Cost
DeptNumber
I was wondering if I generate a report that would hide
Sub-BuildingName if Sub-buildingNumber =0?
I would also like to Hide BuildingName if Sub-
BuildingNumber Is not =0.
Any help would be greatly appreciated.
Ed

In the report, code the Detail Section format event (if the controls
are in the detail section):
[Sub-Building Name].Visible = Not Sub-BuildingNumber =0
[BuildingName].Visible = Not [Sub-BuildingNumber] = 0

 

[Brian Flewwelling]

Thanks Fred, that is useful.

Now what if the conditional fields constitute a separate line in the detail
section? How can we recover the blank space?

Tried 'can shrink' and 'can grow' properties of the Detail Section and that
didn't work!

Brian

I have a query with some of the following fields
BuildingNumber
Building Name
Sub-BuildingNumber
Bub-BuildingName
Location
TotalArea
Building Replacement Cost
DeptNumber
I was wondering if I generate a report that would hide
Sub-BuildingName if Sub-buildingNumber =0?
I would also like to Hide BuildingName if Sub-
BuildingNumber Is not =0.
Any help would be greatly appreciated.
Ed

In the report, code the Detail Section format event (if the controls
are in the detail section):
[Sub-Building Name].Visible = Not Sub-BuildingNumber =0
[BuildingName].Visible = Not [Sub-BuildingNumber] = 0

--

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

 

[Brian Flewwelling]

Got it from another post here
Make the fields 'can grow' and 'can shrink' properites YES on that line
Brian

Thanks Fred, that is useful.

Now what if the conditional fields constitute a separate line in the detail
section? How can we recover the blank space?

Tried 'can shrink' and 'can grow' properties of the Detail Section and that
didn't work!

Brian

I have a query with some of the following fields
BuildingNumber
Building Name
Sub-BuildingNumber
Bub-BuildingName
Location
TotalArea
Building Replacement Cost
DeptNumber
I was wondering if I generate a report that would hide
Sub-BuildingName if Sub-buildingNumber =0?
I would also like to Hide BuildingName if Sub-
BuildingNumber Is not =0.
Any help would be greatly appreciated.
Ed

In the report, code the Detail Section format event (if the controls
are in the detail section):
[Sub-Building Name].Visible = Not Sub-BuildingNumber =0
[BuildingName].Visible = Not [Sub-BuildingNumber] = 0

--

Fred
Please only reply to this newsgroup.
I do not reply to personal email.