Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

oledb index and filter settings

Sort:
You are not authorized to post a reply.
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).
      You are not authorized to post a reply.