title: Creating static drop down list in Jaspersoft ireport
body: <p>I'm creating a report in "Jaspersoft iReport designer 5.6.0". What I'm trying to do is add a parameter (a static list that contains values such as: 6 months, 3 months ...). When the user chooses one of these options, I should be able in the Report query, to get the value that the user has chosen, so I can deliver the results upon that selection. I don't want to use jasper server.</p>
  
  <p>Is this possible?</p>
  
  <p>this is my query:</p>
  
  <pre><code>SELECT
       DISTRICT."DKEY" AS DISTRICT_DKEY,
       DISTRICT."PROVINCE_ID" AS DISTRICT_PROVINCE_ID,
       DISTRICT."DISTRICT" AS DISTRICT_DISTRICT
       DISTRICT."DURATION" AS DISTRICT_DURATION
  FROM
       "dbo"."DISTRICT" DISTRICT
  where DISTRICT."DKEY" = $P{parameter1}
  </code></pre>