Share
Report
35hi all..
DP CLASS
[SRSReportParameterAttribute(classStr(InventQuarantineAnnouncmentContract))]
class InventQuarantineAnnouncmentDP Extends SRSReportDataProviderBase
{
date fromDate, toDate;
InventQuarantineAnnouncmentContract contract;
InventQuarantineAnnouncement inventQuarantineAnnouncementTmp;
}
[SRSReportDataSetAttribute(tableStr(InventQuarantineAnnouncement))]
public InventQuarantineAnnouncement getInventQuarantineAnnouncement()
{
select * from inventQuarantineAnnouncementTmp;
return inventQuarantineAnnouncementTmp;
}
public void populateTmpTable(date _fromDate, date _toDate)
{
InventQuarantineOrder inventQuarantineOrder;
//CompanyInfo companyInfo = CompanyInfo::find();
select * from inventQuarantineOrder
where (inventQuarantineOrder.QuarantineDate >= _fromDate)
&& (inventQuarantineOrder.QuarantineDate <= _toDate);
inventQuarantineAnnouncementTmp.clear();
inventQuarantineAnnouncementTmp.ItemId = inventQuarantineOrder.ItemId;
inventQuarantineAnnouncementTmp.Name = inventQuarantineOrder.Name;
inventQuarantineAnnouncementTmp.QuarantineId = inventQuarantineOrder.QuarantineId;
inventQuarantineAnnouncementTmp.QuarantineDate = inventQuarantineOrder.QuarantineDate;
inventQuarantineAnnouncementTmp.Qty = inventQuarantineOrder.Qty;
// inventQuarantineAnnouncementTmp.Status = inventQuarantineOrder.Status;
//inventQuarantineAnnouncementTmp.CompanyLogo = CompanyImage::findByRecord(companyInfo).Image;
inventQuarantineAnnouncementTmp.insert();
}
public void processReport()
{
contract = this.parmDataContract() ;
fromDate = contract.parmfromDate();
ToDate = contract.parmtoDate();
this.populateTmpTable(fromDate, toDate);
}i have a one row in a table of invent quarantine and when i display a report it shows multiple rows rather than one ..where is the problem? 
All responses (
Answers (
