Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

oledb index and filter settings

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Ruma Malhotra
Veteran Member
Posts: 412
Veteran Member
6/5/2009 12:41 PM

    I am trying to set up a range in the index or filter options for an ole db report.

    The range is like

    (field >= 600 and field <=620_ or (field>=700 and field <=720).

    Has anybody been able to set this up on the filter or index of a table in lawson. i have tried  the , ; & | to give me a combination but oledb is not acceptiony any of these characters. It allows the first part but not the rest.

    tia.

     

    Ruma Malhotra
    Veteran Member
    Posts: 412
    Veteran Member
    6/5/2009 12:42 PM
      The filter should be as the fol.

      (field >= 600 and field <=620) or (field>=700 and field <=720).