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

  • Thread starter Thread starter Ed Dobbin
  • Start date Start date
E

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
 
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
Click to expand...

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
 
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





fredg said:
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
Click to expand...

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.
Click to expand...
 
Got it from another post here
Make the fields 'can grow' and 'can shrink' properites YES on that line
Brian

Brian Flewwelling said:
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





fredg said:
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
Click to expand...

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.
Click to expand...
Click to expand...
 
Back
Top