Hide a field in a report

S

srkey1

I am building a report using fields that are in tables. One of the
fields in the report is "Do Not Use". I want to build an expression
that says if "Do Not Use" is marked "1" in the table, then remove that
line from the report. If "Do Not Use" is marked "0", keep that line
in the report. Please help! Thanks!
 
K

KARL DEWEY

In your query use a calculated field like this --
Hide_Field: IIF([Do Not Use] = 1, Null, [Do Not Use])
Then in the report set the textbox Can Grow property to Yes and drag the
size of the textbox to a hairline. If the output is null then it will not
show in the report.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Weekly Report 2
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Insert Multiple Fields without Dialog closing between each... 0
Multiple Projects using a Resource Pool 0
Possible to Combine reports to's to a single box? 0
MS Project Center-Autolink column fields 0
Canshrink question!! 2

Top