Using Questionnaire Names as a BI Report Parameter

If it is required to report on answered Questionnaires, and to be able to select the Questionnaire Name in a BI Parameter window, follow these steps:

• In the Report Designer, create a parameter with
  
  - Value Type = String
  - Visibility = Hidden
• In the SQL statement which returns the report details, use the "Questionnaire Name" in the WHERE clause and compare it against the above parameter, for example:
  
  WHERE "dbo"."rt_questionnaire"."name" = ${paramQnName}
• In the SAI360 Web Application, create a BI Report Parameter with the following details (based on the above example):
  
  - Name = paramQnName
  - Label = Please select Questionnaire
  - Field Input Type = QuestionnaireName

This parameter will ONLY return the names of those Questionnaires which already have been answered and saved at least once.

Questionnaires for which the templates have been created, but so for no-one has answered, will NOT be included in this list.