Hi friends A puzzler.
My client has a report based on a table TBills, with a column TMiles_Tot (REAL) in it. His goal is simple: if TMiles_Tot has a value in it, the report should print "xxx Miles" where xxxx is the number in TMIles_Tot rounded off to nearest whole number. If TMiles_Tot is NULL, NOTHING should print. I created this set of expressions at the R> prompt which work just fine: (Note: his quotes setting is " ", his wild cards are the standard % and _) SET VAR vMiles_Tot = 21 SET VAR vprint = (IFNULL(TMiles_tot," ",(CTXT(NINT(TMiles_tot))&"Miles"))) When we try to create the same expression in the Reports module, based on the column name: vprint = (IFNULL(TMiles_tot," ",(CTXT(NINT(TMiles_tot))&"Miles"))) We get a wierd error message: error - syntax is incorrect for the command vMiles_Tot I've tried setting a variable to the column to remove the _ character in case that's the problem: rMilesTot = (CTXT(NINT(TMiles_Tot))) rprint = (IFNULL(.rMilesTot," ",(.rMilesTot & "Miles"))) The first time I tried it I got: "error - syntax is incorrect for the command vMiles_tot" Again! But when I copied the command to the clipboard, and pasted it into the variable define box again, it worked!! Any ideas what this wierdness is? David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261
