...
See luActivity configuration documentation for more information.
...
Adding Activities
In Future Student Maintenance > Activities tab, press Add
Select the required Activity Code and ensure that the Mail Request flag is ticked.
Pupulate the status
For more information: Future Student Maintenance - Activity tab
Extracting Data for Activity Letters using crspFutureActivityPrint
Stored Procedure explained - crspFutureActivityPrint
The stored procedure crspFutureActivityPrint is not used by the Print button on the Activity tab of Future Student Maintenance. It can be used directly by MS Query or Crystal Reports to extract data for letters and update the Mailed Date/By fields after report generation.
Stored procedure: crspFutureActivityPrint
...
| Name | Type | Description |
|---|---|---|
| @Activity | VARCHAR(15) | Activity code as created in lookup table luActivity |
| @MailedDate | DATETIME | Leave as blank to pick up all activities that do not already have a "MailedDate". By default the procedure will return all records with a blank mailed date as well as all records that have a mailed date of the current date (ie. letters were generated today but perhaps need to re-run the merge). |
| @IgnoreMailFlag | BIT | If set to 0 then the stored procedure will only return future student contacts that have the Mail Flag ticked. This is not available from the 'Print' option on the activities tab. |
| @ActivityCreatedBy | VARCHAR(30) | Optional filter to only include activities created by a specific user. This is not available from the 'Print' option on the activities tab. |
| @MailedBy | VARCHAR(50) | Optional override of the Mailed By user name. This is not available from the 'Print' option on the activities tab. |
Adding Activities
...
| tab |
...
| . |
...
Pupulate the status
For more information: Future Student Maintenance - Activity tab
Extracting Data for Activity Letters
Extracting data with MS Query
This provides the most flexibility over the letter content, as it can be changed on the fly.
...
| Code Block |
|---|
OFFER 2018-02-14 00:00:00.000 C 11004 Abdullah Aden Mr Aden Dukker Mr A Abdullah sa (... +all other fields from vFutureContactAddress) OFFER 2018-02-14 00:00:00.000 C 11004 Abdullah Aden Mr Aden Dukker Mr A Abdullah sa +records for every activity and corresponding future student contact with mail flag ticked. |
Extracting Data with a Crystal Report - via Crystal Reports Available
Create a Crystal Report based on crspFutureActivityPrint then create a custom selection screen to match the parameters required by the stored procedure and any other optional paremeters needed to be passed in for formatting or further data filtering.
Extracting Data for Activity Letters using the Print button
Crystal Report
...
Requirements
Create a Crystal Report based on a view that contains the following fields:
| FieldName | Details |
|---|---|
| ActivitySeq | Must be in the dataset used, for example vFutureStudentActivities.ActivitySeq |
| ContactType | Required only if luActivity.ReportPromptContactType flag is ticked for the selected activity code. Create as a report parameter. |
| Activity | Report parameter - can be used for optional additional filtering |
| MailedDate | Report parameter - can be used for optional additional filtering or back update of the database *database update would require a custom report and stored procedure |
| MailedBy | Report parameter - can be used for optional additional filtering or back update of the database *database update would require a custom report and stored procedure |