If you have any feedback on how we can make our new website better please do contact us and we would like to hear from you.

Custom Reports & Services

Custom Reports and Consulting Services

Everyone wants a cost effective solution for those times when you need outside expertise in developing a custom report. We have been working with companies to turn their data into information since 1989. And now you can get what you need for projects large and small.

Our engagements are for as little as 3 hours. So whether your organization requires management level reports from Crystal Reports or you need a special report from your SMS|HOST system or the DESCO ESC system, we can give you the professional expertise you need.

Prices:

3 Hour Minimum @ $180 per hour10 Hour Block @ $150 per hourAll block time purchases must be paid in advance. Unused time expires one year after purchase.

Unlimited Monthly Support Contracts - Starting at $500 per month

The following are proprietary report templates developed by Hammerman Associates Inc. for SMS|HOST users. These templates will significantly reduce the amount of time needed to customize your reports. You'll realize significant cost savings as a result.

Created for hotels that use the PAR-SMS HOST property management system

OccTrack provides a data warehouse that can be used to create powerful revenue management and occupancy reports.

Features: The heart of the HOST system is the IN_RES table with one record for each reservation. OccTrack converts this and other tables into an easily analyzed database with one record per occupied unit night. For example, a reservation for four nights in the IN_RES table is recorded as one record with an arrival and departure date. We would convert this into four records and add a field holding the occupancy date.

In addition to exploding the current reservation table we combine that data with the historical reservation table. For all reservations that have checked out we record the night by night room charges actually incurred. For all future reservations we record the charge that the guest has agreed to based on the selected package.

OccTrack is written and FoxPro and it produces standard FoxPro tables. The resulting data can be analyzed with R&R or Crystal Reports. It can easily be imported into Excel.

Usage: Most properties run the program once a day in order to refresh the analytical tables.

Support: Hammerman Associates, Inc. provides the first year support as part of the selling price. After that, the annual support charge is equal to 15 percent of the sale price.

Discounts available for multiple properties. Call for pricing or request a quote

One-Click Revenue and Occupancy Forecasting

The one-click forecast report provides all the essential information you need to accurately forecast revenue and occupancy.

NormalBlocks

NormalBlocks is a program that “normalizes” four complex tables in the HOST system related to group bookings. It is used by advanced report writers to determine group pickups, occupancy and availability.

LostBiz

LostBiz provides a day-by-day report showing refusals and the reasons for the refusal as registered in the PAR-SMS HOST system

HOSTExport

HOSTExport automatically exports selected guest attributed from the HOST system to a third party on a daily or weekly basis without any user intervention. It is typically used by properties that use a third party survey firm to ascertain guest satisfaction with their stay.

RunMyReportNow

Has this happened to you? You have developed (or had someone develop) a killer report and you find that you are running it every day. Perhaps you are printing it. Perhaps you are exporting to a *.CSV file. But everyday you need to get into R&R, find the report, and run it. Too many keystrokes! Too much to remember! RunMyReportNow is a simple program that creates a desktop shortcut that will run the with less than 5 keystrokes. Cost: $99.﻿