Apply Range In Datasource

You can add range in Datasource object like that through coding.

If you want to add range in report then you can this code in DP class. If you want to add range in Form datasource then you can write this code in executeQuery() method of form . Or else anywhere where you want to add range in dataSource object.

  QueryBuildDataSource qbds;
            QueryBuildRange         qbr;
            qbds = this.query().dataSourceTable(tableNum(CMSProspectParentTable));
            qbr = qbds .addRange(fieldNum(CMSProspectParentTable , ParentId));
            qbr.value("CMS-00001");
            qbr.status(2);