Simply Answers
Simply Answers is a very easy reporting tool that lets you extract information from your database in a fast, easy, and secure manner.
Included Features
Simply Answers Scheduled Reports
Simply Answers HR software now has a very useful feature that lets you schedule queries to be emailed automatically to up to five people at a given time.
For example:
Take a Free Trial today. View the Quick Tour
Security
Simply Answers HR software incorporates the Simply Personnel HR software security. Simply Personnel HR software will check the following:
Simply Answers HR software will automatically ignore employees who do not have access to this information showing instead a ‘0’ value.
Simply Answers HR software will check the current job record to figure out the employee’s department and location. If a job record that has no end date is current and cannot be found Simply Answers HR software will ignore the record.
On each employee’s work tab you can enter the existing payroll numbers assigned to this employee and then select then company. For organizations and businesses running only one payroll this will be main.
Take a Free Trial today. View the Quick Tour
A Simple Query
Simply Answers HR software consists of three sections. The first section is a tree of different fields that can be queried. The second section is the grid of results. The third section is a display containing the Structured Query Language to be used for the query.
To start your query click on the ‘+’ sign to open the tree. Now double click on the required field. In this example click on the ‘+’ next to the Employee and then double click on the Surname field. The Surname field will then be added into the ‘SQL to be used for this query’ labeled section.
Now press the ‘Run Query’ button on your toolbar. You will see the query results. You can now choose to add even more fields by double clicking on a different field. In this case you would double click on the Firstname field, then run the query once more.
To being a new clean query, click on the ‘New Query’ button. This will give you clear results and the SQL sections will be ready for you to choose new fields. At this point you can also choose to export the results to Excel or print your query results.
Take a Free Trial today. View the Quick Tour.
Grouping and Sorting
You can sort and group queries easily in Simply Answers HR software.
Let’s try an example:
You will now notice the results have changed to group employees by gender. A useful count of both male and female employees is given to you. To un-group the employees just simply drag the ‘Gender’ button off of the group by section. This will return you back to a normal view of the query. To sort a column just click on the header of that column. This will change the sort order so you can sort multiple columns just by holding down the shift key while selecting the columns.
Take a Free Trial today. View the Quick Tour
Totals and Counts
Simply Answers HR software lets any column have a basic total applied to it.
Let’s view a simple example:
You can now review the results. At this point you may also see Pay values shown multiple times for a single employee but this is no reason to worry because the query is giving you both current and historic salary values. Now click on the Formula symbol located on the pay column. It looks like an ‘E’ and then select the option to see the Maximum, Minimum, Average, and Sum.
Once you press ‘OK’ you may have to scroll down to the end of the query so you can increase the size of the Pay column allowing you to view the returned values. In the results section you can Gender column to the ‘group by section’ labeled ‘Drag a column header here to group by that column’. You will now be able to view the same values shown inside the Gender Group. To un-group you just drag the Gender button off of the ‘group by section’ and you are returned back to your normal query in normal view.
Take a Free Trial today. View the Quick Tour
Filtering
By choosing the filter option located on every column, you can quickly filter all of the results.
Let’s look at a simple example:
You will be able to view the returned results. At this time you may also see Pay values displayed more than one time for the same exact employee but this is no concern because the query is displaying both current and historic salary figures. Choose the Formula symbol on the pay column that looks similar to an ‘E’. Then choose the option that lets you see the Average, Minimum, Maximum and Sum. Once you press OK you might have to scroll down to the bottom of the query to increase the size of the pay column in order to view the results. In the result section, drag the Gender column to the ‘group by section’ labeled ‘Drag a column header here to group by that column’. You will now be able to see the exact same values shown within the Gender Group. If you want to un-group, simply drag the Gender button off of the ‘group by section’ and you will be returned back to the normal view of your query.
Take a Free Trial today. View the Quick Tour


