How to use advanced query to search other database tables
How to use Advanced Query to search other database tables
1) Open Advanced Query (Reporting > General). Select one of the available tables on the right.
2) Find the name of the database table you want to query. You can find the table names in SQL or by opening the database connections in a crystal report. Otherwise - email or call Support to find out the table name that contains the data you need.
3) Change the table name at the bottom and click in the top area to move focus to the new table.
4) Select Columns and query data as you normally would.
Related Articles
Advanced Billing Calcs, Price Tables and Billing Templates
How to use a multiple filters on a live report
Hello, thank you for selecting this quick tutorial for enhancing your knowledge of Execupay. This video will show you how to use a date filter on a live report. https://www.loom.com/share/e4815f0eada144a59640184df4e9c21d don't forget to give me a ...2025 FWH calc template
Template is in the ATTACHMENT tab 2025 Publication 15-T Our System uses Worksheet1A: Employer's Withholding Worksheet for Percentage Method Tables for Automated Payroll Systems Publication 15-T (2025), Federal Income Tax Withholding Methods | ...EEO-1 Changes for 2019
8/27/2019 The EEO-1 changes for 2019 include the Component 2 requirement. To learn more about he federal rules, go here: https://www.eeoc.gov/employers/eeo1survey/about.cfm https://www.eeoc.gov/employers/eeo1survey/alternate-formats.cfm ...