I have a form with 1 subform. The subform has a grid with 2 calculated fields. The calculation is correct in the SQL query, but most of the calculations show on the grid as way off. If any one could look at my example and detect an error, I would appreciate it.
Debian 9 LibreOffice 5.2.2.2 Data base is hsqldb 2.3.4 wizzardC:\fakepath\STUFF.odb
Hello,
It took some effort but do have an answer.
First note the posted .odb was not in proper format. Had to break it down and create a split DB from the internals. then copy the form over.
Took a while just to figure out what you were doing. Think there may be further problems with the design but put the effort into solving your problem.
Here is your SQL for the grid control:
Please note the links from table to table. IT in "SOLD" to "ITEMS" is OK. But IT from "ITEMS" to CU in "CUSTOMER" makes no sense at all. In fact you are missing an entire table here for linking:
By adding in the "INVOICE" table and correcting the links, the calculations are correct. You were using the incorrect discounts with the incorrect linking.
That grid control is base upon a query where data is arriving from multiple tables. As noted in my answer, I believed there were other design problems. This is part. With a quick glance, this should be part of the entry for adding a item to the invoice. I would only use the grid as a guide to the complete order as it currently stands.
Asked: 2020-04-26 20:31:45 +0200
Seen: 94 times
Last updated: Apr 27 '20
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
You can upload your sample file here. To do this, edit your initial question and click the paper clip icon (attachment).
I seem to have trouble adding a zip file.
The zip file is not on the list
Hello,
Just change the extension from
.zipto.odband note that in your edited post.Also, is there a reason you are using such an old version of LO?
I clicked on the paperclip, clicked on my zip file, it showed up and i clicked ok. But zip was not an accepted file. or maybe it just didn't get there yet
zipis not allowed. Change this to something acceptable likeodband when we download to review, as you will note this change, we will change it back tozipso it will work properly. See my previous comment. This is commonly done for this situation.There is a reason, Sometimes the db doesn't work the same after an upgrade. I will try the extension Change
@Pumper,
Have worked with split since LO v4.3.x and now in the 6.x series. Yes, there is an occasional problem but have not held upgrades for that many versions. Your decision. Just didn't understand.
I can't seem to get the zip file small enough. The .odb 1,5 m and when I zip it, it is still 1.5m ??
I will make a new embedded db file and upload.