/***********************Class declaration****************************/
/// <summary>
/// Declares variables and tables for the <c>AssetBookCompare</c> report.
/// </summary>
[
SRSReportQueryAttribute(querystr(CustReport))//,
// SRSReportParameterAttribute(classstr(AssetBookCompareContract))
]
public class CustReportClassDP extends SRSReportDataProviderBase
{
TmpCustTbl TmpCustTbl;
}
/********************** GetTempData*****************************/
[
SrsReportDataSetAttribute(tablestr(TmpCustTbl))
]
public TmpCustTbl getTempData()
{
select TmpCustTbl;
return TmpCustTbl;
}
/*******************insertTempData *********************************/
private void insertTempData()
{
CustTable CustTable;
CustTrans CustTrans;
TmpCustTbl.CurrencyCode = CustTrans.CurrencyCode;
TmpCustTbl.CollectionLetterCode = CustTrans.CollectionLetterCode;
TmpCustTbl.CashPayment = CustTrans.CashPayment;
TmpCustTbl.CancelledPayment = CustTrans.CancelledPayment;
TmpCustTbl.BirthDate_IT = CustTable.BirthDate_IT;
TmpCustTbl.BirthPlace_IT = CustTable.BirthPlace_IT;
TmpCustTbl.Currency = CustTable.Currency;
TmpCustTbl.Blocked = CustTable.Blocked;
TmpCustTbl.BankAccount = CustTable.BankAccount;
TmpCustTbl.AccountNum = CustTable.AccountNum;
TmpCustTbl.insert();
}
/**********************************processReport **********************************/
[SysEntryPointAttribute]
public void processReport()
{
CustTable CustTable;
CustTrans CustTrans;
Query query = new Query(this.parmQuery());
QueryRun queryRun;
queryRun = new QueryRun(query);
while (queryRun.next())
{
CustTable = queryRun.get(tablenum(CustTable));
CustTrans = queryRun.get(tablenum(CustTrans));
this.insertTempData();
}
}
/// <summary>
/// Declares variables and tables for the <c>AssetBookCompare</c> report.
/// </summary>
[
SRSReportQueryAttribute(querystr(CustReport))//,
// SRSReportParameterAttribute(classstr(AssetBookCompareContract))
]
public class CustReportClassDP extends SRSReportDataProviderBase
{
TmpCustTbl TmpCustTbl;
}
/********************** GetTempData*****************************/
[
SrsReportDataSetAttribute(tablestr(TmpCustTbl))
]
public TmpCustTbl getTempData()
{
select TmpCustTbl;
return TmpCustTbl;
}
/*******************insertTempData *********************************/
private void insertTempData()
{
CustTable CustTable;
CustTrans CustTrans;
TmpCustTbl.CurrencyCode = CustTrans.CurrencyCode;
TmpCustTbl.CollectionLetterCode = CustTrans.CollectionLetterCode;
TmpCustTbl.CashPayment = CustTrans.CashPayment;
TmpCustTbl.CancelledPayment = CustTrans.CancelledPayment;
TmpCustTbl.BirthDate_IT = CustTable.BirthDate_IT;
TmpCustTbl.BirthPlace_IT = CustTable.BirthPlace_IT;
TmpCustTbl.Currency = CustTable.Currency;
TmpCustTbl.Blocked = CustTable.Blocked;
TmpCustTbl.BankAccount = CustTable.BankAccount;
TmpCustTbl.AccountNum = CustTable.AccountNum;
TmpCustTbl.insert();
}
/**********************************processReport **********************************/
[SysEntryPointAttribute]
public void processReport()
{
CustTable CustTable;
CustTrans CustTrans;
Query query = new Query(this.parmQuery());
QueryRun queryRun;
queryRun = new QueryRun(query);
while (queryRun.next())
{
CustTable = queryRun.get(tablenum(CustTable));
CustTrans = queryRun.get(tablenum(CustTrans));
this.insertTempData();
}
}
Dedicated to my friend Irfan Shaik
ReplyDelete