How do I use Inserts to place constants or variables into fields in CRD?

The Inserts module, which pops up automatically, gives you the ability to drag and drop constants, variables, user constants and data items into almost any field in CRD.

Insert Menu

crd inserts

Inserts is arguably one of the most versatile features in CRD. This feature enables the advanced schedule types to work, deals with variety of parameters, and customizes outputs for recipients.

  • The insert function is activated in two ways:
    1. CRD will automatically launch the insert module at points where it can be used. (e.g. in a wizard's parameter screens).
    2. In the field into which you wish to insert a function, right-click and select Insert.
  • The following types of constants are available:
    • Crystal Constants (@@Crystal Constants)
    • CRD Constants (@@CRD Constants)
    • User Defined Constants (@@User Defined Constants)

CRD Constants

crd inserts crd constants

 

crd inserts crd constants 2
  • To use CRD constants, select @@CRD Constants from the Type list and then select the constant you want from the resulting Name list. Here is a list of constants to choose from:
    • Current Group Value: Return the current group value.
    • Current Temp File Path: Return to the temp file path.
    • CurrentDate: Returns the current date.
    • CurrentDateTime: Returns the current date and time.
    • CurrentDay: Returns the current day date.
    • CurrentMonth: Returns the current month number.
    • CurrentMonthName: Returns the current month name.
    • CurrentScheduleName: Returns the name of the current schedule or package.
    • CurrentShortMonthName: Returns the name of the short month.
    • CurrentShortWeekDayName: Returns the name of the short week.
    • CurrentTime: Returns the current time.
    • CurrentWeekDayName: Returns the day name of the day the schedule is run.
    • Current Year: Returns the current year.
    • End Last Year: Returns the date of the last day of last year.
    • Exported File Name: Returns to the name of the exported file.
    • First Day of the Next Month: Returns to the first day of the next month.
    • First Day of this Month: Returns to the first day of the current month.
    • FiscalWeek: Returns to the fiscal week.
    • Friday Last Week: Returns the date for last Friday.
    • Friday This Week: Returns the date for this Friday.
    • Key Parameter Value: Returns the current key parameter value in use by a dynamic schedule.
    • Last Day of the Month: Returns to the last day of the month.
    • LastResult: Returns to the last result.
    • Last Run: Returns to the last run of the schedule or package.
    • LastestResult: Returns to the latest result of the schedule or package.
    • LatestRunTime: Returns to the latest run time of the schedule or package.
    • Monday Last Week: Returns the date for last Monday.
    • Monday This Week: Returns the date for this Monday.
    • MonthEndLastMonth: Returns the date of the last day of last month.
    • MonthStartLastMonth: Returns the date of the first day of last month.
    • SaturdayLastWeek: Returns the date for last Saturday.
    • SaturdayThisWeek: Returns the date for this Saturday.
    • Schedule Owner: Returns to the schedule owner.
    • Scheduled Time: Returns to the scheduled time.
    • StartThisYear: Returns the date of the first day of this year.
    • SundayLastWeek: Returns the date for last Sunday.
    • SundayThisWeek: Returns the date for this Sunday.
    • ThursdayLastWeek: Returns the date for last Thursday.
    • ThursdayThisWeek: Returns the date for this Thursday.
    • TuesdayLastWeek: Returns the date for last Tuesday.
    • TuesdayThisWeek: Returns the date for this Tuesday.
    • WednesdayLastWeek: Returns the date for last Wednesday.
    • WednesdayThisWeek: Returns the date for this Wednesday.
    • Year Start Last Year: Returns the date of the first day of last year.
    • Yesterday: Returns the date of before.

User Defined Constants

crd inserts user defined

 

crd inserts user defined 2
  • To use User Defined Constants, select @@User Defined Constants from the Type list and then select the constant you want from the resulting Name list. Or select New to create a new constant. You can insert other constants and create a new formula of your own.
  • For more information about User Constants Data, click here.

Parameters

crd inserts parameters
  • Use these to insert the current report parameter value into an email, report name, etc.

Event-Based Data

crd inserts eb
  • Used with event-based schedules.
  • Data from the database record or email body which triggered off the event can be inserted into emails, reports etc.
  • For instructions on how to parse the body of an email, see the last section of this page.

Data-Driven Data

crd inserts dd
  • Used with data-driven schedules. Data from the data driver can be inserted in all possible areas to drive the schedule.

Data Item

crd inserts data items
  • Construct a SQL statement to collect the information from a database field. Selecting this option will bring up the Data Items Module.
    • Here you can pick an already existing SQL script, or construct a new one to query a database and return a specified value.

User Defaults

crd inserts user defaults
  • Default Attachment: This will insert the attachment in the Default Attachment field from the User Defaults menu (in Options).
  • Default Message: This will insert the wording in the Default Message field from the User Defaults menu (in Options).
  • Default Signature: This will insert the wording in the Default Signature field from the User Defaults menu (in Options).
  • Default Subject: This will insert the wording in the Default Subject field from the User Defaults menu (in Options).
  • For more information on User Defaults, click here.