Previous TopicNext Topic


How to define a dynamic query

  1. On the Query page of a data set, define a SQL query, such as:
  2. SELECT CUSTOMERNAME FROM CUSTOMERS 
    
  3. Create a table in the report layout that uses this data set.
  4. Create a report parameter, such as a String parameter called "passName".
  5. In Edit Data Set, choose Property Binding, and define the query text to use the report parameter that you created:
  6. "SELECT CustomerName From CUSTOMERS WHERE CustomerName LIKE 
    '" + params["passName"] + "'" 
    
  7. Choose OK.


(c) Copyright Actuate Corporation 2006

Previous TopicNext Topic