Cub Reporter
Version: 8.0.1 (for Access 97)

CR81d.mdb - shareware/demo
CR81.mdb - 1-5 license version
CR81u.mdb - unlimited licenses with source code version

Peter's Software

http://www.peterssoftware.com	- Other Access tools
http://www.peterssoftware.com/buy.htm	- To register Cub Reporter online


-----------------------------------------------------------------------

Contents
========

1.  What Is Cub Reporter?
2.  Installing Cub Reporter
3.  Running Cub Reporter
4.  Registering Cub Reporter
5.  Contacting Me
6.  Report Requirements
7.  Known Problems
8.  New Features in this Version


-----------------------------------------------------------------------

1.  What Is Cub Reporter?
=========================

Cub Reporter is a set of Microsoft Access objects that you can add into your application to expand the capabilities of your Access reports. It lets you dynamically change your report criteria, sorting, and grouping options so that you don't need multiple copies of the same basic report to fit each report variation. You create the basic report layout, and Cub Reporter does the rest!

Cub Reporter eases report maintenance because layout, criteria, and sorting changes only need to be made in one place. Users also have the ability to easily create and save their own criteria, and sorting options, which will free you up for other tasks. Once saved, the criteria and sort is available to all Cub Reporter-enhanced reports. 

It's simple to implement - Just import the Cub Reporter objects into your database, and add one line of code to your report OnOpen event procedure! Then, when you open your report, you'll be able to dynamically set your report criteria and sorting options via the provided Criteria and Sort forms. Cub Reporter works with most types of Access reports, but is best suited to the type of reports in the supplied report examples and templates.


-----------------------------------------------------------------------

2. Installing Cub Reporter
==========================

If you've received a zip file archive ("CR8#.zip" or "CR8#d.zip", where "#" represents the Cub Reporter version), extract the zipped files to a folder on your computer.

If you've received a self-extracting .exe file ("CR8#.exe" or "CR8#d.exe"), double-click the .exe file and follow the instructions on the screen to install Cub Reporter on your computer. 


To run the demo, double-click the "CR8#d.mdb" (or "CR8#.mdb") file in the folder you installed to, or select "Cub Reporter for Access 97" from the start menu.


To use Cub Reporter with your Access application:

1. Import the following objects from the "CR8#d.mdb" (or "CR8#.mdb") database into your application database:

Tables:	  tblCRCriteria
	  tblCRSort
Forms:	  frmCRCriteria
	  frmCRSort
Reports:  rptCRTemplate1
	  rptCRTemplate2
	  rptCRTemplate3
	  rptCRTemplate4
	  rptCRTemplate5
	  rptCRTemplate6

2. Add a reference from your database to

"CR8#d.mdb" (if you have the Access 97 demo),
"CR8#.mdb" (if you have the Access 97 1-5 license version), or
"CR8#u.mdb" (if you have the Access 97 unlimited licenses with source code version).

Or, if you have registered Cub Reporter with source code, you can import the "basCubReporter" module from "CR8#u.mdb" directly into your applicaion database.

3. Use the supplied report templates to create great looking, easy-to-maintain reports. Just make a copy of the template, add a RecordSource (table name or query name), detail fields, and totals. If there are any additional fields that you might want to sort or group on, add them in the report sorting and grouping dialog box.

Or,

Add one line of code to your existing report's OnOpen event procedure:

cr_ReportOnOpen Me, Cancel	'Cub Reporter

(Cub Reporter works with most types of Access reports, but is best suited to the type of reports in the supplied report examples and templates.)

4. Open your report to run Cub Reporter. That's it!



TO ADD A REFERENCE from your database to another database ("CR8#d.mdb"):
1.	In your database, open a Module (any Module) in design mode.
2.	On the Tools menu, click References, and click Browse in the References dialog box.
3.	In the Files Of Type box, click Databases (*.mdb, *.mda, *.mde).
4.	Locate the "CR8#d.mdb" file.
5.	Click OK.
You should now see Cub Reporter in the list of available references in the References dialog box.
6.	Check it, and close the references dialog.


-----------------------------------------------------------------------

3. Running Cub Reporter
=======================

When your Cub Reporter-enhanced report is opened, a criteria form will appear. Users can select a pre-defined criteria, or create a new one. Upon clicking "Next", a sort form will appear. Users can select a pre-defined sort, or create a new one. Clicking "Finish" will cause the report to appear with the specified criteria and sorting and grouping options.

The criteria and sort forms have combo and list boxes that are filled from the report record source fields found in the report detail section, and the report sorting and grouping dialog box. Once a criteria or sort is named using the criteria/sort name text box, it can be located again by using the "Find" combo box at the top of each form.

Using Function cr_OpenReportImmediate:

You can also run Cub Reporter with specific pre-defined criteria and sorting/grouping options by using a supplied function - "cr_OpenReportImmediate". When you use this function to open your report, the criteria and sort forms will not appear.

iReturn = cr_OpenReportImmediate(<Report Name>, <Criteria ID>, <Sort ID>, <Preview T/F>, <Maximize report window T/F>)

	<Report Name> - A string that is the name of the report you wish to open.
	<Criteria ID> - An integer that is the Criteria ID of the criteria table record that contains the criteria you wish to use for your report.
	<Sort ID> - An integer that is the Sort ID of the sort table record that contains the sort that you wish to use for your report.
	<Preview T/F> - "True" will display the report in preview mode, "False" will print the report immediately
	<Maximize report window T/F> - "True" will display the previewed report in a maximized window.

Ex.:  iReturn = cr_OpenReportImmediate("demoEx1", 73, 38, True, True)

-----------------------------------------------------------------------

4. Registering Cub Reporter
===========================

REGULAR MAIL ORDERS
To register Cub Reporter, please send a check made payable to "PETER'S SOFTWARE" for the equivalent of

US$35.95 (1-5 licenses)
US$149.95 (unlimited, royalty free distribution license with source code)
US$114.00 (upgrade to unlimited, royalty free distribution license with source code) to:

	Peter's Software
	Attn: Cub Reporter Group
	1317 Oceanfront #2
	Santa Monica, CA  90401-1025
	USA

Please specify the Access version you are using, and include your e-mail address so I can send Cub Reporter to you immediately!

INTERNET ORDERS AT SOFT-SHOP.COM
To purchase online at Soft-Shop.com with your Visa, Mastercard, American Express, Discover, Switch, or Diners card, go to: 
http://www.soft-shop.com/cgi-bin/product.html?94419103520

For your convenience I have contracted another company, NorthStar Solutions, to process any orders you may wish to place with your Visa, MasterCard, or Discover card.  Please be sure to mention you would like to order Product #1432 - ShrinkerStretcher for Access 2.0, or Product #1433 - ShrinkerStretcher for Access 7.0 & 8.0 (works with Access 2000) when placing your order. Also, please enter a quantity that corresponds to the number of licenses that you require (prices are the same as above):

INTERNET ORDERS AT NORTHSTAR SOLUTIONS
Visit NorthStar Solutions at 
http://www.nstarsolutions.com/900.htm
and fill out their online order form--fast, easy and secure!

PHONED ORDERS
Calls are taken Monday-Friday, 9am-7pm, CST
800 699-6395 (U.S. only.) 
785 539-3731
ask for Product #4255 (Cub Reporter for Access 97) or #4256 (for Access 2000) or #4257 (for unlimited lics Access 97/2000) or #4258 (upgrade to unlimited lics).

FAXED ORDERS
Available 24 hours.
785 539-3743

E-MAILED ORDERS
CompuServe: starmail
America Online: starmail
Internet: starmail@nstarsolutions.com 

Please provide (or be prepared to provide) the following information: 
* The program you are registering:  Product #4255 (Cub Reporter for Access 97) or #4256 (for Access 2000) or #4257 (for unlimited lics Access 97/2000) or #4258 (upgrade to unlimited lics).
* Your mailing address.
* Your Visa, MasterCard, or Discover # and its expiration date (if using credit card).  
* Your E-Mail address (so NorthStar Solutions can send you an E-Mail confirming your order and so I can SEND CUB REPORTER TO YOU. I distribute Cub Reporter exclusively via e-mail.).


-----------------------------------------------------------------------

5. Contacting Me
================

I provide technical support by e-mail to registered users of Cub Reporter only.

I can be contacted at the following address:

info@peterssoftware.com

I process most e-mail and orders within 24 hours of receiving them. If you have not heard from me within 48 hours of sending mail, it is likely that I have a problem with your e-mail address - either the Reply To field in your e-mail program is incorrect, or possibly there is a problem with your mail server. Please contact me again.


-----------------------------------------------------------------------

6. Report Requirements
======================

Cub Reporter may not work well with every type of report or every report layout variation. In addition, there may be a report setting that Cub Reporter does not support. That is why a set of report templates are provided as examples for you.  

If want to use Cub Reporter with one of your existing reports, please take note of the following list of requirements and restrictions: 

* The report record source must be a query or table (not an SQL statement).

* Reports based on parameter queries are not supported by Cub Reporter.

* 2 report subtitle label controls should be defined in your report or page header section and should be named "lblTitle2", and "lblTitle3". The captions for these labels will be manipulated by Cub Reporter.

* An unbound text box control (and an optional label control) should be defined in the group header (see the report templates for examples). These controls will be manipulated by Cub Reporter to display group information.

* Calculated fields in report detail section will not be reflected on the criteria or sort form. If you want to use your calculated fields in criteria statements, or sorts, then include the calculation in the report's underlying query.

* Cub Reporter's sorting and grouping capabilities are limited by the number of sorting and grouping levels defined in your report. If you want more sorting and grouping levels to be available on the Cub Reporter sort form, you have to first create them in your report (up to 5 levels).

* The only report "GroupOn" property setting supported by Cub Reporter is "Each Value" (which is the default).


-----------------------------------------------------------------------

7. Known Problems
=================

* It is not possible to put parenthesis around certain criteria and make full use of the  "And" and "Or" operators on the criteria form.

-----------------------------------------------------------------------

8. New Features In This Version
===============================

This is version 1.0 and it is entirely new
