Tuesday, July 16, 2013

Testing SSRS report output using RDP class through Job

static void TestEOSCompensation(Args _args)
{
EmplContractTmp EmplContractTmp;
Query q;
date sdate = str2Date('31/12/2012',123);
//date sdate = systemDateGet();
NSGEOSCompensationDP dataProvider = new NSGEOSCompensationDP();
NSGEOSCompensationContractClass contract = new NSGEOSCompensationContractClass();
contract.parmUptoDate(sdate);
q = dataProvider.parmQuery();
q.dataSourceTable(tableNum(EmplContract)).addRange(fieldNum(EmplContract, EmplId)).value("I0012"); //000545"); //"000042"); //"DNG998877");
dataProvider.parmDataContract(contract);
dataProvider.processReport();
EmplContractTmp = dataProvider.getEmplContractTmp();
while select EmplContractTmp
{
print(EmplContractTmp.EmplId);
print(EmplContractTmp.StartDate);
print(EmplContractTmp.Housing);
print(EmplContractTmp.Phone);
print(EmplContractTmp.Fuel);
print(EmplContractTmp.Other);
print(EmplContractTmp.CompensationValue);
print (EmplContractTmp.DeptDescription);
print (EmplContractTmp.JobPosition);
print(EmplContractTmp.DeptDescription);
print(EmplContractTmp.BasicSalary);
print(EmplContractTmp.Housing);
print(EmplContractTmp.Transportation);
print(EmplContractTmp.Other);
print(EmplContractTmp.TotalPackage);
print(EmplContractTmp.StartDate);
print(EmplContractTmp.UptoDate);
print(EmplContractTmp.EoSDaysOfService);
print(EmplContractTmp.CompensationValue);
}
pause;
}

No comments:

Post a Comment