Examples of Filters in Time

Example 1:

Entry in the Expression pane:

  • [Office].[Office] is equal to ‘TOR’
  • [Employees.Address].[City] is equal to ‘Toronto’

Displayed in the Filter pane:

  • [Office].[Office] is equal to ‘TOR’ AND [Employees.Address].[City] is equal to ‘Toronto’

 

Example 2:

If you want to build a filter that means the following:

  • Receivables source field not equal to 'WP'

SQL requires 2 expressions

  • ( LTRIM([Receivables].[Source]) is not equal to 'WP' ) OR
  • ( LTRIM([Receivables].[Source]) is blank )

The second expression must be included to get any transactions that have a blank source field to appear. 

Comments and suggestions about this article and our software are greatly appreciated. As a user of our products, you are in a unique position to provide ideas that have an impact on future releases of this and other products.

Before contacting Technical Support, please consult the online Help and any other documentation included with this package as your first source to solve the problem.

If you require additional assistance, you can contact CaseWare® Technical Support by contacting your nearest CaseWare distributor.

When you contact CaseWare® Technical Support, you should be at your computer and have your documentation at hand. Be prepared to provide the following information:

  1. Your Client Number.
  2. The product version number, found by clicking the Help menu and selecting About.
  3. The type of computer hardware you are using.
  4. The software version number of MS-Windows.
  5. The exact wording of any messages that appear on your screen.
  6. A description of what happened and what you were doing when the problem occurred.
  7. A description of how you tried to solve the problem.

CaseWare Support

NORTH AMERICA

Email: support@caseware.com

Phone: 416-867-9504

GLOBAL

Find your local distributor

Copyright ©2017 CaseWare International Inc

| Visit us: www.caseware.com | Share your feedback with Google Moderator |


Follow us     



Legal