Reporting

Reporting is a requirement for every Hauled Waste program and each program may want a broad range of data and formatting within these reports. LinkoHW approaches these needs in two fashions.

First: we provide 50 system reports that can be used from a variety of locations from within our software. Clicking on the Reports Button can access these system reports.

Second: We do not expect that our system reports will meet each Hauled Waste Program’s exact reporting needs and that is why we created the Flexible Reporter. The flexible Report allows the user to edit existing system reports to add or remove data, and customize the format for each report. These reports can then be saved and used throughout the system.

Note: Reports from the compliance assistant are not modifiable with the Flexible Reporter.

Top of Page

System Reports

Access the Reports screen by selecting the “Reports” button on the status bar at the bottom of a screen.

Tabs	Description
System Reports	Displays all of the System Reports and Letters that can be applied from the previous screen. This form is displayed each time the Report button is clicked. The only difference will be what reports and letters are displayed.
User Reports	Displays all of the User Reports and Letters that can be applied from the previous screen. This form is displayed each time the Report button is clicked. The only difference will be what reports and letters are displayed.
Mail Merge Letters	Print out Mail Merge report – letters.
Items	Description
Choose a Report to View	List of Reports available to view. Double-click a report name to preview it
Contact Priority	Choose contacts by priority that you would to send letters. Contact Priority comes from the Contact Priority on the Contacts screen in the Hauler Management.
Contact Type	Choose contacts by Contact Type that you would to send letters. Contact Type comes from the Contact Type field on the contacts screen.
Preview Report	Opens the report or letter. For ease of use we automatically open all letters in MS Word as well as within our software.
Export / View Data	Opens a datasheet view of the information displayed in the report or letter chosen. This information can then be easily exported to Excel.

Top of Page

Report Location and Functionality

Top of Page

Sample Management

Sample Event Details	The details of each event for the selected Industry
Samples by Quarter	Detailed list of each event in each quarter for the selected Industry
Samples Signed Off Late	Summary of late sign-offs
Samples Signed Off Late Crosstab	Statistical analysis of late sign-offs
Samples Signed Off Late Summary	Monthly count of late sign-offs

Disposal Management

Disposals by Date and Waste Type	Provides a list of disposals by Date and the type of waste disposed.
Disposals by Date and Waste Type Summary	Provides a summary list of disposals by Date and the type of waste disposed.
Disposals by Facility Class, Date, Waste Type	Provides a list of disposals by Facility Classification, Date of Disposal and the type of waste disposed.
Disposals by Hauler, Date, Waste Type	Provides a list of disposals by the Hauler / Pumper, Date of Disposal and the type of waste disposed.
Disposals by Map Category, Date, Waste Type	Provides a list of disposals by Map Category, Date of Disposal and the type of waste disposed.

Top of Page

Result Management

Results by Industry and Sample	Sample details for each parameter in the selected Sample
Results by Parameter	Parameter result details for the selected Sample

Top of Page

Violation Management

Count of Facilities w/Violations by Class, Type	Provides a count of unique facilities with violations by month, quarter and year
Violation Summary	Provides a detailed list of violations during each period
Violation Summary by Classification, Facility, Type	Provides a list of facilities with violations for each period
Violation Summary with Enforcements	Provides a detailed list of violations and associated enforcements.

Top of Page

Violation Details

Violation Summary	Provides a detailed explanation of the selected violation
Violation Summary with Enforcements	Provides a detailed explanation of the selected violation and associated enforcements.
Violations with Related Items	Detailed description the violation and each related event

Top of Page

Enforcement List View

Summary by Class, Facility, Type	Provides a sorted list of enforcements
Summary by Class, Type	Provides an anonymous count of enforcements by month
Enforcements with Related Items	Provides a detailed explanation of each enforcement
NOV with 1 Violation	Letter template
NOV with Multiple Violations	Letter template
Violations and Enforcements	Provides a detailed list of violations and associated enforcement.

Top of Page

Event Management

Event Summary by Complete Date, Performed By	Chart of the number of events each inspector completed each year and month
Events by Complete Date	List of the events completed each month
Events by Due Date	List of events ordered by due date by month with totals for month
Events by Due Date w / Addr. And Phone	List of events due with the Facility name and phone by month
Events by Facility	Detailed list of events for each hauler
Events by Facility (List)	List of events for each hauler
Generic Event Details	List of generic events
Inspection Event Details	List of inspection events
Permit Event Details	List of Permit Events
Pump Out Details	List of Pump Outs

Top of Page

Compliance Assistant

Event Violations	Listing of the events that are in non-compliance
Facilities in SNC	List of the Facilities that have one or more events in non-compliance.
Event Table Report	Event violations in table format.

Top of Page

Groups and Queries

Contact Labels	Print on adhesive labels, addressed to contact
Contact Letter	Blank letter with facility contact
Industries by SIC (List-Summary)	Ordered list of Facilities by SIC number.
Driver Summary	Facility report with driver information summary
Hauler (Contacts, Notes, Vehicles)	Detailed facility report with contacts, facility notes, and vehicle information.
Hauler (List – Summary)	List of facilities with compliance status
Hauler (List)	List of basic facility info and contacts.
Industry Contacts	Rolodex inserts
Site Address Labels	Print on adhesive labels, industry name only
Site Sampling Plan	List of pollutants associated with monitoring points

Top of Page

Flexible Reporter

Access the Flexible Reporter screen from the Menu Bar at the top of the screen by selecting File à LinkoHW Administration à Flexible Reporter. This is where you ‘create’ reports. You do not print reports from here. That should only be done from the Reports screen previously discussed.

The Flexible Reporter button on the Linko Menu Bar (Reports à Create Reports and Letters) is used to modify existing system reports to create new user reports. The Flexible Reporter offers our users the ability to take our current system reports and customize them. To use the report writer, the user is expected to have an intermediate understanding of creating reports with Access.

When User reports are created, those reports are automatically distributed to other users of the software.

Using the Flexible Reporter:

Report Category	Choose Data Source to use for the report you would like to create.
System Reports / User Reports	Choose a report to modify and use. Click on New or Preview button if you select a System Report. Click on New, Preview, Edit or Delete if you select a User Report.
New	Select an existing report, and Choose NEW to open the report in the Access Design mode where it can immediately be modified and then saved as a New User report. Use standard Access report design protocols to modify the report. Now click on the close or the Save button. You will be prompted to save the changes you have made. Click on the YES button.
Edit	Used to modify existing user reports. Note: You cannot alter or delete a system report. You create a NEW report from a system report and then save it as a USER report. Then you can come back at any time and EDIT the User report you made.
Save	When returning to the report editor screen after modifying a report, click on the Save button across from the User Reports Section. Now enter the desired description for the Name of the report. Your report is now saved as a user report.
Preview	Will open the report in the view mode. The view mode cannot be modified; however you can see what the finished product looks like.
Cancel	Exits without saving.
Delete	Will remove the chosen report from our system.

Top of Page

Mail Merge

Using the power of MS Word, you can create your own Templates and then reuse those templates for creating and sending letters to your Facilities. LinkoHW will “merge” the data from the database into the Templates that you create. This allows you to create one Mail Merge Letter template and use it with all of your Facilities and each time the appropriate Facility’s name, address and other information will be displayed in the letter.

Mail Merge Category	Choose Data Source to use for the report you would like to create.
Mail Merge Letters	Choose a system report to modify and use. Click on the either the New or Preview button. The user can select Mail Merge letters that are not based on contacts. These letters are identified “(No Contacts)” and are based on the Hauler information alone.
New	Enter a name for your letter and click ok. The text will be added to the Mail Merge Letters section. Next choose the letter and click on the edit button. When adding a new letter, you can simply edit an existing letter in MS word and copy the text from your existing letter and paste it over the text in the document you are currently editing. Keep names short and descriptive. Avoid using: , : ; ‘ “ ? / @ # $ % & *. The name you enter will be added to the Mail Merge Letters list. Next choose that letter and click on the Edit button.
Edit	Opens existing Mail Merge document to be edited. Keep in mind after you save the Word document you still must click on the save button on the Mail Merge screen in the Linko Software.
Preview	Will open the Mail Merge Letter in MS Word and will ‘merge’ fake data into the letter so you can have an idea of what the letter might look like later when you go to use it.
Delete	Will remove the chosen report from our system.
Saving	When returning to the report editor screen, click on the Save button across from the User Reports Section. Now enter the desired description for the report. Your report is now saved as a user report.

Top of Page