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)

Verified answer

Jeson 120 on at

Like (1)

Report
[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

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

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

done.

Was this reply helpful? Yes No

Join the conversation

Community site session details

report showing multiple rows rather than one row

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

report showing multiple rows rather than one row

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates