Ask Your Question

Report Filtering in BASE

asked 2018-03-23 14:27:21 +0200

rfeigels gravatar image

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!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-03-23 16:03:20 +0200

Ratslinger gravatar image

updated 2018-03-23 20:13:53 +0200


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.


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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-23 14:27:21 +0200

Seen: 149 times

Last updated: Mar 23 '18