Control Specific Issues With Crystal Reports


Accessing System Option Information

Often you may need to access options that are configured in Control. Rather than access them from the database (which is possible through the UserOptions table), which can be difficult, you can "ask" Control for the information directly.
To do so, create a parameter in Crystal Reports using the following naming convention:
  • Option_<<OptionName>>
where <<OptionName>> is replaced by the (internal) Control name for the specific option.
Example: The name of the "Company" option for some franchises is "Family". To be able to pull the word "Family", you can create a parameter with the name "Option_CompanySingular". Then, in the report, instead of hard coding the word "Company", use that parameter.

Any parameter starting with "Option_" will be hidden from the user.

Some of the Control options you can access are:

  • CompanySingular
  • CompanyPlural
  • ContactSingular
  • ContactPlural
  • SalespersonSingular
  • SalespersonPlural
  • CourseSingular
  • CoursePlural
  • OrderSingular
  • OrderPlural
  • EstimateSingular
  • EstimatePlural
  • WorkAssignmentSingular
  • WorkAssignmentPlural
  • IsClientSingular
  • IsClientPlural
  • ContractPeriodSingular
  • ContractPeriodPlural
  • CourseEventSingular
  • CourseEventPlural
  • CourseSectionSingular
  • CourseSectionPlural
  • CompanyOrigin
  • ProofDateName
  • ContactPositionSingular
  • FranchiseType
  • UseDivisions
  • SalespersonCount

How it Works:
When Control comes across a parameter name that starts with "Option_", it will strip off the "Option_" to get the option name.

Then it will look for an option with that name in the user options. If it doesn't find one, it will check the store options. If it still doesn't find one it will check the application options. If it is still not found it returns a blank string.

See Also