We are working with a 3rd party application which includes L&L 29 for generating reports. I’m trying to modify some reports.
In this case, we have an invoice with a table containing orderlines. This table is fairly simple with a header and datalines. The datafields are filled from the application database and are form-specific (eg. invoices have different fields available as for a purchaseorder for example). All the dataline cells in this table have a content which starts with “Artikelregels.“, for example “Artikelregels.Product“. This lists all the available “Artikelregels“ with details I guess. Now, as for the problem, I’d like to modify a cell, so it contains the sum from “Artikelregels.Prijsbijstelling.Bijstellingsbedrag“, so one level down. Any way I tried, it lists all of the values for “Bijstellingsbedrag“ in the underlying database it can find for that combination of “Artikelregel” and “Prijsbijstelling”. This results in many lines per orderline, because there are more than one per orderline. I just simply want the sum those amounts so each orderline has its corresponding total. Regular summing doesn’t seem to help here.
So, I’m trying to find a solution, and I thought a sum variable would help here. But I’m uncertain how to define it. I feel the field hierarchy plays a part, but I can’t put my finger on it. There are also other tables in this report, for example to display the invoice totals. I’d like to make modifications there as well, but that’s for later as I’m getting stuck already.
Unfortunately, the vendor isn’t very helpful in creating the needed fields from the application. I’m looking to get some help how to define an expression or sum variable to achieve this. Thank you very much!
without knowing the programming language and the type of data source that is used, it is rather difficult to give a proper recommendation or information about how to implement what you want to achieve.
The application and database are based on Progress OpenEdge. It also seems that I’m missing some functions like LL.CurrentContainerItem, which should help creating the right sum otherwise. Does that help?
Although I mostly understand what an expression does, I’m not very experienced in creating those. Let alone creating something in a different programming language.
Also wondering if group headers/footers would work here? I tried grouping on line number and creating a sum variable which should aggregate the numerical value from “Artikelregels.Prijsbijstelling.Bijstellingsbedrag“, but somehow it keeps displaying 0.
yes, depending on the used environment, there can be functions missing. I talked with our development department, but unfortunately it still is pretty vague and the issues could be due to a multitude of different possibilities. So we think that this needs to be discussed with your vendor, as he knows his environment.
Maybe it would be a possibility that your vendor contacts our List & Label support so we could take a look with them directly?
