How to get reserved quantity from batch reservation for a batch order?

(1) Share

Report

Posted on by RSX

204

Hi,

I have a SSRS report, where I need to print the reserved qty lines for a batch order.
Path : From Batch order > formula lines > inventory action pane > Batch reservation.
In this there is edit method for the control named "Reservation". This is a formdatasource method.

I need to add this in a condition to get the reserved qty lines. What is the correct approach here?

As per the below Screenshot, I need to display 2nd and 3rd line which has "Reservation" value only. But as Reservation is a formdatasource method, I'm unable to add that in a if condition.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

André Arnaud de Cal... 306,846 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

What exact SSRS report are you referring to? Is it a standard report or a customization? If it is a customization, is the report based on a query or data provider class?

Was this reply helpful? Yes No
RSX 204 on at

Like (0)

Report
Copy link

Link copied!

It is a customization, and it is based on data provider class.

Was this reply helpful? Yes No
André Arnaud de Cal... 306,846 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi RSX,

You can insert records in a temporary table and copy the logic of the form datasource method. Then after filling the details, you can remove the lines that don't have a value in the Reservation field on the temporary table.

Was this reply helpful? Yes No