Share
ReportHi experts,
I have multiple line item in my sales order, but in my case whenever i run my report it only shows 1 item number, can somebody help? thank you....
You’re offline. This is a read only version of the page.
Hi experts,
I have multiple line item in my sales order, but in my case whenever i run my report it only shows 1 item number, can somebody help? thank you....
Your code seems to be simple. So better, as Girish suggested, create a runnable job and see what it returns. Otherwise go to SSMS and write the same query what it returns and make your x++ code exactly.
You need to debug the code to find out the issue. Otherwise, it's difficult for us to find the issue from the code.
Create a runnable class and paste the while select code into the runnable class and add info log and check.
Thanks,
Girish S.
Hi sir this is my papoulate code whats the missing im a new trainee here in our company.
public void populatetemptable1()
{
IntercompanyPurchSalesReference Reference;
SalesTable localSalesTable;
PurchLine localPurchLine;
PurchTable localPurchTable;
ttsbegin;
while select SalesId from localSalesTable
join Reference
where Reference.SalesId == localSalesTable.SalesId
join localPurchLine
where localPurchLine.PurchId == Reference.PurchId
{
TempT1.PurchId = localPurchLine.PurchId;
TempT1.PurchPrice = localPurchLine.PurchPrice;
TempT1.PurchQty = localPurchLine.PurchQty;
TempT1.LineAmount = localPurchLine.LineAmount;
TempT1.ItemId = localPurchLine.ItemId;
TempT1.SalesId = localSalesTable.SalesId;
TempT1.SalesStatus = localSalesTable.SalesStatus;
TempT1.insert();
}
ttscommit;
}
Hi, is it Query Based or RDP report? If query based then write SQL statement as per query and see how many records are retrieved. If RDP, then debug the method in DP class where you are inserting records in table.
Hi JPM,
Debug the code and find out how many lines are inserted into the temp table. Or for testing purpose you can convert report table type to regular and after troubleshooting you can change it to temp db. again.
Thanks,
Girish S.
Might be you are using first only in your code. Can you please send the code?
#1
André Arnaud de Cal...
292,850
Super User 2025 Season 1
#2
Martin Dráb
231,723
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
All responses (
Answers (