The SQL Connection Option lets you easily access and display
real-time CounterPoint data in charts, graphs, and tables.
It allows you to run a client application, such as
Microsoft Excel, and view the CounterPoint data files
in the format you want.
As you create your own spreadsheet reports, they automatically
become available on the SQL Connection
Reports menu. A Refresh menu selection is provided to
display updated data values.
The SQL Connection can also be used with tools such
as Crystal Reports, Microsoft Access, or Visual Basic to
produce more sophisticated applications that access the
CounterPoint data files directly to present information.
Crystal Reports is a valuable tool for defining your own
reports and presentations of your business information.
The SQL Connection provides you the tools you need
to access your CounterPoint business records using Crystal
Reports. (Crystal Reports is purchased separately.)
Crystal reports can be output to paper, to a file on disk,
or viewed interactively on the screen. Interactive screen
displays provide very powerful capabilities to view summarized
information, then drill down for more detail
in a particular subject area. Reports and displays can
include text as well as graphical information, such as
charts and images.
A complete listing of CounterPoint tables in English
format is provided, along with linking information that
is valuable for reports that require multiple tables.
CounterPoint is installed with four sample Crystal
reports. Reports designed using Crystal will appear
automatically on the SQL Connection Menu (the
same place where you can run Excel reports).
)
)
