In Base, I created a report that shows the data from all records. Let’s say there are 100 records and 80 of them have a field with the value of X in it. I only want the report to show the records that have the value of X. In Microsoft Works, I could create a report filter where [fieldname] = X. I can’t figure out how to create the same kind of filter here. Thank you!
Hello,
Reports are based upon a table or a query. Use a query to output wanted information only and use that as input to report generation. For even more flexibility, you can have the query using parameters.
Edit:
Should also mention you can do some conditional printing within Report Builder itself. For example, selecting the Detail Line only printing lines with text box named COLOR having a value of “blue”, the conditional print entry would be:
[COLOR] = "blue"
You do lose the flexibility of a query with a parameter.
If this answers your question please tick the (upper left area of answer). It helps others to know there was an accepted answer.