Adhoc Report:
Adhoc reporting is a tool that was designed as an easy way for the user to query the database.
Since we selected Accounting reports in the first drop down, we now have access to general account, last bill report, and missing bill report in the next drop down.
If you would like to create a new report follow the following steps.
The order the fields will show up on the report will be the order that you add the fields.
After selecting the sort order you will then be able to select whether you would like the information to be sorted in ascending or decending order.
The next area that you will want to populate is the criteria section. This section allows you to specify the data that will be pulled back in this report.
As you can see above you can select a field name like Account Number. From there you can fill out different options like equal to, in, not equal to.
The last section that you have the option of filling out is the aggregate function area. In this section you can select to aggregate the data from a variety of fields including Account Number, Bill Month, Bill Create Date, Bill Status Indicator, and Commity Type. Depending on the the category choosen you will will receive different aggregate functions. You can see an example of this below.
After you have made all of you selections above you will have some options regarding what to do with this report. You can either: