BS&A Software Blog

In order to pull specific data out of the Building Department program (tables, reports, Excel spreadsheets, or charts), it is necessary to run a filter.

Creating a filter is the program’s way of sifting through ALL of its records and displaying ONLY the info you need. Think of a filter as a sieve: it lets some information through while blocking out the rest.

Applying a filter has the same look and feel in every area of the program. The first tab shows “common” report filters and gives the most used options for a given table. The second tab shows more advanced filter options, allowing you to pull more detailed information or data from other sources (depending on the nature of the filter).

Edit Filter Condition gives you the ability to change the operator for a given value: Equals will show only records that match exactly; Not Equals will show all records BUT that value; Between allows you to pull a range of information (effective for dates); Starts With will pull only records that begin with the value (very useful when searching by record number); and so on.

On the Advanced Filter Options tab, you can also change the adjoining operators from ALL to ANY to control what the filter must match for more control over the data you receive.

When you have created a filter, you can save it to your database to use again later. The filter can be loaded from anywhere in the program, saving you time and allowing other users to view the same results.

While simple filters are generally easy enough to input and understand, more advanced filters can pose difficulties. If you are filtering data and receiving “No records exist” messages, it is possible that a condition or operator is incorrect. Please feel free to contact tech support for assistance.

Posted in: Community Development

Views: 7359

Interested in learning more?

Get in touch and we would be happy to schedule a detailed overview of our solutions. 


Why use BS&A Software?

Our top priority is quick customer responsiveness. When you are trying to complete your payroll process, you can’t wait several hours for your software company to call you back. You need an answer now.

See more reasons

In the BS&A Tax and Assessing programs the most important improvements to our productivity are the comment section and the ability to attach documents to the parcel. For example if a parcel received a correction to the taxable value from a Michigan Tax Tribunal you can attach a copy of the documentation from the State. This improves the amount of time required to answer questions when you have all of the information at your fingertips. As for the comment section, if you have left a message for a property owner to return your call anyone cal...

Continue Reading »

Donna Leitermann, Treasurer

Need help finding the right software solution?

We’ll help you find the software that fits your needs. Get in touch with our team to get started.

Get in Touch

Software Support & Training

Your resource for everything you need to learn about your software. Can’t find what you’re looking for? Get in touch for support.

Featured Tutorial

Check out our learning center for more videos
Employee Self Service

Employee Self Service

Employees can view prior checks, request changes to personal employment information, check leave balances, etc.

Added in AccessMyGov

Have questions or want to learn more about our software? We’re here to help! Feel free to

Get in Touch