I have a Delivery Docket that uses a stored proc.
A subreport prints only the detail lines for parts that use expiry dates (using selection export record formula) on the last page and calculates how many days between delivery date and expiry date. The total number of cartons "cartoncount" is also printed. The SP writes the invoice total cartoncount on each line so I was able to put a formula field in the subreport report footer to display the cartoncount. This works fine unless there are no detail lines that use expiry dates.
In Jiwa 6 JiwaLibSelectNumberFromJiwa would return a field from the database. Is there anything similar in Jiwa 7 or other way to get the cartoncount.