Finance | Project Operations, Human Resources, ...

SSRS Report Multiple Line Item

(0) Share

Report

Posted on by JPM00

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....

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

Might be you are using first only in your code. Can you please send the code?

Was this reply helpful? Yes No
Suggested answer

GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
JPM00 4 on at

Like (0)

Report
Copy link

Link copied!

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;

}

Was this reply helpful? Yes No
GirishS 27,833 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No