title: Cognos issue with conditional page display
body: <p>I'm trying to make a page display conditionally based on a prompt in Cognos 10.1.</p>
  
  <p>I have a prompt page with a dropdown that is populated by a query named PromptSQL.  PromptSQL returns a table with two columns, Value and Descr.  The Value Prompt on the prompt page has had the following properties altered:</p>
  
  <pre><code>Query: PromptSQL
  Use Value: Value
  Display Value: Descr
  Parameter: Location
  </code></pre>
  
  <p>I created a boolean variable, vShowPage, to determine if one of the report pages, Page 2, should be displayed.  The code under vShowPage is simply:</p>
  
  <pre><code>?Location? in ('12', '15', '20')
  </code></pre>
  
  <p>So, I only want the "Page 2" page to be printed if the location selected is 12, 15 or 20.</p>
  
  <p>I then selected "Page 2" under Report Pages and associated vShowPage to the Render Variable property.  When I validate the report I get the following error:</p>
  
  <blockquote>
    <p>RSV-VAL-0032 The following expression is not valid: ?Location? in
    ('12','15','20'). If the item exists in a query but is not referenced
    in the layout, add it to a property list. CRX-API-0005 An error
    ocurred at or near the position '0'. The variable named '?Location?'
    is invalid.</p>
  </blockquote>
  
  <p>I also tried changing the variable to a String Variable, but listing all of the possible values will be problematic.  But even the small test I did using the String Variable resulted in the same error.</p>
  
  <p>I tried adding PromptSQL to the Query property of Page 2 and checking the Value column under the Properties property.  I even tried checking Value and Descr.  These all produced the same error.</p>
  
  <p>I used this link from IBM's web-site as my template for doing this: <a href="http://www-01.ibm.com/support/docview.wss?uid=swg21342081" rel="nofollow">How To: Hide a report page based on a prompt</a></p>
  
  <p>Any help figuring this out would be greatly appreciated.</p>