Dynamics Community Forum Thread Details

Hi experts,
i am getting my RDP report filter Lookup empty although table has data.Below is my code written.
/*Contract Class*/

[DataContractAttribute
,SysOperationContractProcessingAttribute(Classstr(PRSalarySheetUIBuilder))]
class PRSalarySheetContract
{
    List  prDimension;
    List  prPayGroupCode;
    List  prPayPeriodCode;
}

public void new()
{
    prDimension = new List(Types::String);
    prPayGroupCode =  new List(Types::String);
    prPayPeriodCode = new List(Types::String);

}

[
DataMemberAttribute(identifierStr(PRDimension)),
SysOperationLabelAttribute(literalstr("Dimension Department")),
SysOperationDisplayOrderAttribute("1"),
AifCollectionTypeAttribute(extendedTypeStr(PRDimension), Types::String)
]
public List parmPRDimension(List _prDimension= prDimension)
{
    prDimension = _prDimension;
    return prDimension;
}

[
DataMemberAttribute('Pay GroupCode'),
SysOperationLabelAttribute(literalstr("Pay GroupCode")),
SysOperationDisplayOrderAttribute("2"),
AifCollectionTypeAttribute(extendedTypeStr(PRPayGroupCode), Types::String)
]
public List parmPRPayGroupCode(List _prPayGroupCode = prPayGroupCode)
{
    prPayGroupCode = _prPayGroupCode;
    return prPayGroupCode;
}

[
DataMemberAttribute('Pay PeriodCode'),
SysOperationLabelAttribute(literalstr("Pay PeriodCode")),
SysOperationDisplayOrderAttribute("3"),
AifCollectionTypeAttribute(extendedTypeStr(PRPayPeriodCode), Types::String)
]
public List parmPRPayPeriodCode(List _prPayPeriodCode = prPayPeriodCode)
{
    prPayPeriodCode = _prPayPeriodCode;
    return prPayPeriodCode;
}

    
/*Contract Class*/

/* UI Builder Class*/

class PRSalarySheetUIBuilder extends SrsReportDataContractUIBuilder
{
    DialogField  dialogOffDimension,dialogPayPeriodCode,dialogPayGroupCode;
    SysLookupMultiSelectGrid msCtrloffDimension,msCtrlPayPeriodCode,msCtrlPayGroupCode;
    PRSalarySheetContract contract;

}
public void build()
{
    contract = this.dataContractObject();

    dialogOffDimension = this.addDialogField(methodStr(PRSalarySheetContract,parmPRDimension), contract);
    dialogPayGroupCode = this.addDialogField(methodStr(PRSalarySheetContract,parmPRPayGroupCode), contract);
    dialogPayPeriodCode = this.addDialogField(methodStr(PRSalarySheetContract,parmPRPayPeriodCode), contract);
}
public void OffsetDimLensionLookUp(FormStringControl _control)
{
    msCtrloffDimension = SysLookupMultiSelectGrid::construct(_control, _control);
    msCtrloffDimension.parmQuery(this.OffsetDimensionQuery());
    msCtrloffDimension.run();
}
private Query OffsetDimensionQuery()
{

    Query query = new Query();
    QueryBuildDataSource queryBuildDataSource,qbds;

    queryBuildDataSource = query.addDataSource(tableNum(PREmployeePayments));


    queryBuildDataSource.fields().dynamic(false);
    queryBuildDataSource.fields().clearFieldList();

    queryBuildDataSource.addSelectionField(fieldNum(PREmployeePayments, OffsetDimension));

    return query;

}
public void PayGroupCodeLookUp(FormStringControl _control)
{
    msCtrlPayGroupCode = SysLookupMultiSelectGrid::construct(_control, _control);
    msCtrlPayGroupCode.parmQuery(this.PayGroupCodeQuery());
    msCtrlPayGroupCode.run();
}

private Query PayGroupCodeQuery()
{

    Query query = new Query();
    QueryBuildDataSource queryBuildDataSource,qbds;

    queryBuildDataSource = query.addDataSource(tableNum(PRPayGroupPayPeriod));

    queryBuildDataSource.fields().dynamic(false);
    queryBuildDataSource.fields().clearFieldList();

    queryBuildDataSource.addSelectionField(fieldNum(PRPayGroupPayPeriod, PayGroupCode));

    return query;
}
public void PayPeriodCodeLookUp(FormStringControl _control)
{
    msCtrlPayPeriodCode = SysLookupMultiSelectGrid::construct(_control, _control);
    msCtrlPayPeriodCode.parmQuery(this.PayPeriodCodeQuery());
    msCtrlPayPeriodCode.run();
}
private Query PayPeriodCodeQuery()
{

    Query query = new Query();
    QueryBuildDataSource queryBuildDataSource,qbds;

    queryBuildDataSource = query.addDataSource(tableNum(PRPayGroupPayPeriod));

    queryBuildDataSource.fields().dynamic(false);
    queryBuildDataSource.fields().clearFieldList();

    queryBuildDataSource.addSelectionField(fieldNum(PRPayGroupPayPeriod, PayPeriodCode));
    
    return query;
}

public void postbuild()
{
    super();

    dialogOffDimension = this.bindInfo().getDialogField(this.dataContractObject(),methodStr(PRSalarySheetContract,parmPRDimension));
    dialogOffDimension.registerOverrideMethod(methodStr(FormStringControl, lookup),methodStr(PRSalarySheetUIBuilder,OffsetDimLensionLookUp), this);
    if (dialogOffDimension)
    {
        dialogOffDimension.lookupButton(2);
    }


    dialogPayPeriodCode = this.bindInfo().getDialogField(this.dataContractObject(),methodStr(PRSalarySheetContract,parmPRPayGroupCode));
    dialogPayPeriodCode.registerOverrideMethod(methodStr(FormStringControl, lookup),methodStr(PRSalarySheetUIBuilder,PayGroupCodeLookUp), this);
    if (dialogPayPeriodCode)
    {
        dialogPayPeriodCode.lookupButton(2);
    }

    dialogPayGroupCode = this.bindInfo().getDialogField(this.dataContractObject(),methodStr(PRSalarySheetContract,parmPRPayPeriodCode));
    dialogPayGroupCode.registerOverrideMethod(methodStr(FormStringControl, lookup),methodStr(PRSalarySheetUIBuilder,PayPeriodCodeLookUp), this);
    if (dialogPayGroupCode)
    {
        dialogPayGroupCode.lookupButton(2);
    }


}
public void postRun()
{
    //super();
    //this.dialog().dialogForm().formRun().controlMethodOverload(false);
} 

/* UI Builder Class*/


/* RDP Class*/

[SRSReportParameterAttribute(classStr(PRSalarySheetContract))]
public class PRSalarySheetDP extends SRSReportDataProviderBase
{
    PRSalarySheetTemp   pRSalarySheetTemp;
    PREmployeePayments  pREmployeePayments;
    PRPayGroupPayPeriod pRPayGroupPayPeriod;
}

[SysEntryPointAttribute(false)]
public void processReport()
{
   

    PRSalarySheetContract           contract;
   
    contract        =   this.parmDataContract() as PRSalarySheetContract;

    offDimensionList = contract.parmPRDimension();
    PayPeriodList = contract.parmPRPayPeriodCode();
    PayGroupList = contract.parmPRPayGroupCode();
    
    //
    Logic....
    //


}
All Parameters Lookup show empty.