report showing multiple rows rather than one row

(0) Share

Report

Posted on by suhailbinshuaib

hi all.. 2043.Capture1.JPG

52432.Capture.JPG

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?

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Jeson 120 on at

Like (1)

Report
Copy link

Link copied!
[quote user="suhailbinshuaib"]
hi all..

Fullscreen
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
InventQuarantineAnnouncmentContract contract;
InventQuarantineAnnouncement inventQuarantineAnnouncementTmp;
}
[SRSReportDataSetAttribute(tableStr(InventQuarantineAnnouncement))]
public InventQuarantineAnnouncement getInventQuarantineAnnouncement()
{
select * from inventQuarantineAnnouncementTmp;
return inventQuarantineAnnouncementTmp;
}
public void populateTmpTable(date _fromDate, date _toDate)
{
InventQuarantineOrder inventQuarantineOrder;
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
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?
[/quote]
Check the temporary table if it is set to temporary or regular.

Was this reply helpful? Yes No
suhailbinshuaib 35 on at

Like (1)

Report
Copy link

Link copied!

Thank You..the problem was i forgot make the table as a temp table

thank u for your help

Was this reply helpful? Yes No
Jeson 120 on at

Like (1)

Report
Copy link

Link copied!

Your welcome. Please mark it as answered so that it can help other

Was this reply helpful? Yes No
suhailbinshuaib 35 on at

Like (1)

Report
Copy link

Link copied!

done.

Was this reply helpful? Yes No