Friday, 25 October 2013

find the range of query and display in to ssrs report

 this.queryRun().query().dataSourceTable(tableNum(<YourTableName>)).findRange(fieldNum(<YourTableName>, <Your_Division_FieldName>)).value()



ex:

queryRun.query().dataSourceTable(tableNum(PurchRFQTable)).findRange(fieldNum(PurchRFQTable, VendAccount)).value();



create one field in temporary table and assign in process report
as

     this.getReportParameters();
    //queryRun = new QueryRun(this.parmQuery());
    queryRun = new QueryRun(this.buildQuery(this.parmQuery(),FromDate,ToDate));
    VendEvaluationTmp.ParmVendAccount = queryRun.query().dataSourceTable(tableNum(PurchRFQTable)).findRange(fieldNum(PurchRFQTable, VendAccount)).value();//).this.queryRun().query().dataSourceTable(tableNum(PurchRFQTable)).findRange(fieldNum(PurchRFQTable, VendAccount)).value();
    while(queryRun.next())
    {







No comments:

Post a Comment