Ask Your Question
1

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
0

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

Ratslinger gravatar image

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

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 149 times

Last updated: Mar 23 '18