thanks Ill play with it some more Chip
On Mon, 12 Aug 2019 14:30:30 -0600, Adam Bevan via 4D_Tech wrote: > Hi Chip, > > I know that 'calculated' columns do print in v12 and v16. The only thing I > haven't done is use relate one in my 'calculated' column methods. > > Adam Bevan > Developer & CEO, Argus Productions Inc. > <https://www.facebook.com/ArgusProductions/> > > On Mon, 12 Aug 2019 at 13:28, Chip Scheide via 4D_Tech > <[email protected]> > wrote: > >> I have code which allows me to print a listbox using Print object. >> >> I dynamically build a listbox for use on screen. >> If a user wants to print the listbox, I use the same process to build a >> separate listbox for reporting (as this is generic code for printing >> list boxes). >> >> What I am observing is complex data gathering fails when printing which >> works correctly when displayed. >> The code (see below for an example) is placed into the listbox as a >> calculation column, in a selection listbox. >> When the listbox is displayed on screen, the data (description) is >> properly displayed. >> >> However, the same data is NOT printed, the column where the description >> is to be displayed, is empty of any text. Which leads me to believe >> that the calculation in the calculated column is not being executed. >> >> Any Ideas on how to go about getting this to function correctly? >> >> >> Example calculated column code, the below code is in a method call, and >> is the "calculation" when inserting the calculation column. >> >> >> QUERY([Lab_Adjustments];[Lab_Adjustments]Adjustment_ID=[Adjustments]Adjustment_ID) >> RELATE ONE([Lab_Adjustments]Lab_Inventory_ID) //gets the laboratory >> inventory record >> RELATE ONE([Lab_Inventory]Inventory_Item_ID) //gets the inventory item >> record >> $0:=[Inventory_Items]Description >> >> >> 4D v13 >> Thanks >> Chip >> --------------- >> Gas is for washing parts >> Alcohol is for drinkin' >> Nitromethane is for racing >> ********************************************************************** >> 4D Internet Users Group (4D iNUG) >> Archive: http://lists.4d.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:[email protected] >> ********************************************************************** > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
