Search results for query: *

NO, what I was trying to do was have the user enter a numerical value and then set the LOWEST or HIGHEST Clause based on the value entered. It has been solved, so don't go crazy, it was mainly a syntax error.

focwizard, I don't quite get your point. Are you saying that my code sample is incorrect? Or are you just explaining in depth how the concat operator works? Because the sample I gave is from an actual report, that has been in production and It doesn't seem to fully follow your explanation.

Try this... DEFINE FILE CAR HEAD1/A20 = EDIT(SEATS) | ' SEATS'; LINE/A20 = 'AVERAGE COST'; END TABLE FILE CAR SUM LINE AS ' ' SUM AVE.DEALER_COST AS ' ' ACROSS HEAD1 AS ' ' END

Have you tried this? DEFINE FILE CAR HEAD1/A20 = -SET &HEAD = &MDY | 'AMOUNT'; END TABLE FILE CAR PRINT COUNTRY AS '&HEAD' END It should do what you want, just parse out the year (or what ever you want to put).

Yeah, it was one of them...but I think that may have happened after the initial error and I started playing the syntax. What I think may have been the problem is for some reason or the other it didn't like my expression in the else clause. I changed it to use the ABS function, fixed the typo it...

HI Guys, Iam trying to create a amper variable to substitute the BY HIGHEST verb in my fex but it's not working for me.... I use this code before my define table -* SET -SET &TOP_# = IF &TOP_N.EVAL GT '0O' THEN &TOP_N ELSE &TOP_N.EVAL * -1; -SET &BY_BY = IF EDIT(&TOP_N.EVAL) GT 'O0' THEN...

Hi all, I am trying to conditionally format the negative values in my subfoot line. I have it working for data lines, Grand Totals and my subtotals. But for subfoot it doesn't work as described in the manual. Below is my trial attempts. The first line will color the field red unconditionally...

Thanks craigiep, that's just the syntax I was looking for. Now a second request, how could I incorporate a Focus File with simmilar syntax, so I don't I have the List hardcoded in my fex?

I want both total lines. One, a total of all columns and rows in the report. and a Second with a total of all columns minus certain rows in the report. ON SUBFOOT will give me the break but how do I get the sum minus the list accounts. My problem isn't with the rport break it's more of how do I...

Hi guys, im creating a report where I would like to have two grand-total lines, one a total of all accounts in my report and a second grand-total excluding a group a accounts. If I were doing this in SQL or VB I would do a 'where Account not in(aaaa,bbbb,cccc,...)' but this type of logic isn't...