APS Report Request

 

Report Requirements

Please provide information for each item.  Use N/A if not applicable.  Specify all fields with the database column name (ex. spriden_last_name).

 

1. Person requesting report: 

Jane User

2. Date requested:

3/2/07

3. Data due (if an urgent priority needs to be given to request, please explain:

Need for meeting on April 20, 2007.  Please provide report 1 week before meeting in case I have questions.

4. Description of report:

Summary of gifts for campaign

 

5. Title of report:

GIFTS TO DATE FOR CAMPAIGN

6. All columns with their data source in order:

 

 

Report Column Header

 

Banner field name (from Dynamic Help Query)

 

 

Comments

Name

Spriden_last_name

Separate with comma

 

Spriden_first_name

     

     

     

     

Gift Date

Agbgift_date

     

     

     

     

Gift Amount

Agbgift_tot_amt

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

7. Selection criteria:

Select for campaign MGCAM

 

8. Sort order (ascending or descending):

Sort by last name

9. Subtotals field:

     

 

10. Totals field:

Total on gift amt

 

11. If output file requested in addition to report, list the columns and their data source in the order desired:

     

 

 

 

12. Any pertinent information that will effect the results:

     

 

 

13.  List users who need access to run the report:

Jan Foreman, Lori Warneke, Sandra Smith