Report Writer: Difference between revisions

From SWKLS WIKI
Jump to navigation Jump to search
mNo edit summary
Line 5: Line 5:
# Select the first parameter by which report content will be determined from the Select field to search menu; the screen refreshes to display the Value fields.  
# Select the first parameter by which report content will be determined from the Select field to search menu; the screen refreshes to display the Value fields.  
# Select the desired “matching” type for the search field from the Value menu.  
# Select the desired “matching” type for the search field from the Value menu.  
** Equal – the report will include records in which the content of the search field is an exact match to the value specified.   
## Equal – the report will include records in which the content of the search field is an exact match to the value specified.   
** NotEqual – the report will include records in which the content of the search field is not an exact match to the value specified.   
## NotEqual – the report will include records in which the content of the search field is not an exact match to the value specified.   
** GreaterThan – the report will include records in which the content of the search field is greater than the value specified.   
## GreaterThan – the report will include records in which the content of the search field is greater than the value specified.   
** LessThan – the report will include records in which the content of the search field is less than the value specified.   
## LessThan – the report will include records in which the content of the search field is less than the value specified.   
** Between – the report will include records in which the content of the search field falls between the values specified (inclusive of the specified values).  
## Between – the report will include records in which the content of the search field falls between the values specified (inclusive of the specified values).  
** Like – Used in conjunction with the "%" wildcard. The query will include records in which the content of the search field is similar to the value specified.  
## Like – Used in conjunction with the "%" wildcard. The query will include records in which the content of the search field is similar to the value specified.  
** Title Like Christmas% - This is interpreted as any title that starts with Christmas
## Title Like Christmas% - This is interpreted as any title that starts with Christmas
** Title Like %Christmas – This is interpreted as any title that ends with Christmas
## Title Like %Christmas – This is interpreted as any title that ends with Christmas
** Title Like %Christmas% - This is interpreted as any title that contains the word Christmas
## Title Like %Christmas% - This is interpreted as any title that contains the word Christmas
** Title Like Christmas – This is interpreted the same as Title Equals Christmas
## Title Like Christmas – This is interpreted the same as Title Equals Christmas
## Numbered list item
# Enter the desired value in the Value text boxes.  
# Enter the desired value in the Value text boxes.  
** When specifying date values, select the desired date using the Date Entry Calendar.  
** When specifying date values, select the desired date using the Date Entry Calendar.  
** When selecting values from a menu, click the desired value. To select multiple values, press and hold the Ctrl key, then click each desired value.  
** When selecting values from a menu, click the desired value. To select multiple values, press and hold the Ctrl key, then click each desired value.  
# If desired, click the Add Another Parameter button to add another report parameter.  
# If desired, click the Add Another Parameter button to add another report parameter.  
** The screen refreshes to display an additional Select field to search menu.  
## The screen refreshes to display an additional Select field to search menu.  
** Specify the desired search field and value as described in steps 4 and 5.  
## Specify the desired search field and value as described in steps 4 and 5.  
** Repeat step 6 to add additional parameters as desired.  
## Repeat step 6 to add additional parameters as desired.  
# When all desired search parameters have been entered, click the Select Output Fields button to specify the fields to be included in the report; the Report Writer – Select Output Fields screen displays.  
# When all desired search parameters have been entered, click the Select Output Fields button to specify the fields to be included in the report; the Report Writer – Select Output Fields screen displays.  
# Select the fields to be included in the report:  
# Select the fields to be included in the report:  
** To add a field to the report, highlight the desired field in the List of Available Fields list box, then click the Add button.  
## To add a field to the report, highlight the desired field in the List of Available Fields list box, then click the Add button.  
** To remove a field from the report, highlight the desired field in the Selected Fields list box, then click the Remove button.  
## To remove a field from the report, highlight the desired field in the Selected Fields list box, then click the Remove button.  
** To reposition a field, highlight the desired field in the Selected Fields list box, then click the Move Up or Move Down button as necessary.  
## To reposition a field, highlight the desired field in the Selected Fields list box, then click the Move Up or Move Down button as necessary.  
# Depending on the specific parameters selected for a given report, certain reports can include “duplicate” rows.
# Depending on the specific parameters selected for a given report, certain reports can include “duplicate” rows.
** If you do want to allow duplicate rows in the report, select the Allow duplicates radio button.
## If you do want to allow duplicate rows in the report, select the Allow duplicates radio button.
** If you do not want to allow duplicate rows in the report, select the Unique (distinct) fields radio button.
## If you do not want to allow duplicate rows in the report, select the Unique (distinct) fields radio button.
# When all desired output fields have been selected, click the Save Report button; the Save Report for Future Use dialog displays.   
# When all desired output fields have been selected, click the Save Report button; the Save Report for Future Use dialog displays.   
# Enter a name for the report in the Name of this report text box, then click the Save button; a confirmation dialog displays.  
# Enter a name for the report in the Name of this report text box, then click the Save button; a confirmation dialog displays.  
Line 35: Line 36:
# Select the frequency for which you wish the report to be generated from the Frequency to run menu; either Once, Daily, Weekly or Monthly.  
# Select the frequency for which you wish the report to be generated from the Frequency to run menu; either Once, Daily, Weekly or Monthly.  
# Specify the date and time at which you wish the report to run using the Start Time fields.  
# Specify the date and time at which you wish the report to run using the Start Time fields.  
** Enter the “start date” using the Date Entry Calendar.  
## Enter the “start date” using the Date Entry Calendar.  
# Select the time at which you wish the report to run using the Start Time “h” (hour) and “m” (minute) menus and the AM and PM radio buttons.  
# Select the time at which you wish the report to run using the Start Time “h” (hour) and “m” (minute) menus and the AM and PM radio buttons.  
# Click the Schedule button on the Scheduling Options screen to submit the report request.   
# Click the Schedule button on the Scheduling Options screen to submit the report request.   

Revision as of 20:40, 24 June 2020

Creating a Custom Report

  1. On the Report Writer – Custom Reports screen, select the desired report type from the Create a New Report menu; User, Items, Bibliographic or Combination.
  2. Click the New Report button; the Report Writer – Select Parameters screen displays.
  3. Select the first parameter by which report content will be determined from the Select field to search menu; the screen refreshes to display the Value fields.
  4. Select the desired “matching” type for the search field from the Value menu.
    1. Equal – the report will include records in which the content of the search field is an exact match to the value specified.
    2. NotEqual – the report will include records in which the content of the search field is not an exact match to the value specified.
    3. GreaterThan – the report will include records in which the content of the search field is greater than the value specified.
    4. LessThan – the report will include records in which the content of the search field is less than the value specified.
    5. Between – the report will include records in which the content of the search field falls between the values specified (inclusive of the specified values).
    6. Like – Used in conjunction with the "%" wildcard. The query will include records in which the content of the search field is similar to the value specified.
    7. Title Like Christmas% - This is interpreted as any title that starts with Christmas
    8. Title Like %Christmas – This is interpreted as any title that ends with Christmas
    9. Title Like %Christmas% - This is interpreted as any title that contains the word Christmas
    10. Title Like Christmas – This is interpreted the same as Title Equals Christmas
    11. Numbered list item
  5. Enter the desired value in the Value text boxes.
    • When specifying date values, select the desired date using the Date Entry Calendar.
    • When selecting values from a menu, click the desired value. To select multiple values, press and hold the Ctrl key, then click each desired value.
  1. If desired, click the Add Another Parameter button to add another report parameter.
    1. The screen refreshes to display an additional Select field to search menu.
    2. Specify the desired search field and value as described in steps 4 and 5.
    3. Repeat step 6 to add additional parameters as desired.
  2. When all desired search parameters have been entered, click the Select Output Fields button to specify the fields to be included in the report; the Report Writer – Select Output Fields screen displays.
  3. Select the fields to be included in the report:
    1. To add a field to the report, highlight the desired field in the List of Available Fields list box, then click the Add button.
    2. To remove a field from the report, highlight the desired field in the Selected Fields list box, then click the Remove button.
    3. To reposition a field, highlight the desired field in the Selected Fields list box, then click the Move Up or Move Down button as necessary.
  4. Depending on the specific parameters selected for a given report, certain reports can include “duplicate” rows.
    1. If you do want to allow duplicate rows in the report, select the Allow duplicates radio button.
    2. If you do not want to allow duplicate rows in the report, select the Unique (distinct) fields radio button.
  5. When all desired output fields have been selected, click the Save Report button; the Save Report for Future Use dialog displays.
  6. Enter a name for the report in the Name of this report text box, then click the Save button; a confirmation dialog displays.
  7. Click the Yes button if you wish to schedule the report; the Schedule This Report dialog displays.
  8. Select the frequency for which you wish the report to be generated from the Frequency to run menu; either Once, Daily, Weekly or Monthly.
  9. Specify the date and time at which you wish the report to run using the Start Time fields.
    1. Enter the “start date” using the Date Entry Calendar.
  10. Select the time at which you wish the report to run using the Start Time “h” (hour) and “m” (minute) menus and the AM and PM radio buttons.
  11. Click the Schedule button on the Scheduling Options screen to submit the report request.