Liveware Publishing Support Forum

aFor the purpose of this report I need to export in cross-tabulated format. With a column for each month. The only way I can get this to work is to set up a calculation for each field. ____JuneName: iif(NameMonth=^June^,TrimLeft,^ ^)__JulyName: iif(NameMonth=^July^,TrimLeft,^ ^) ____With the report_...

Using Version 12.0.002 __I am linking 2 tables with a calculated field where the first column on the link to table has a certain value like A,B,C, D. then the next Colum is the exact Match to my other table. So the Calculation looks like "A"+VVEND(6 character field). Then a Scan Link and a...

Arrggg. That is so simple, that worked thanks so much.

nope, invalid argument.

Unit Field ^R3****^ represent the actual unit types.

Are you using table In_Trn only or are you using In_res or In_guest too?

I am trying to create a calculated field that will return the result of another Calculated field,R_Split, if the conditions are met, if they are not met then it would be blank. I can get it to work in all ways but the R_Split portion.______IIF(UNIT= ^R4*****^ OR UNIT =^R3*****^ OR UNIT= ^R2*****^ OR...