Recent content by tektipsMem

Sorry to reply late. Thanks synapsevampire, retype your suggestion works when I use it this way: if isnumeric({table.stringIDnumber})then val({table.stringIDnumber})mod 111111111 Good tips dgillz, will be handy to use in future. TTM

Oops, when I refresh it, it gave the same "The string is non-numeric" error. So, is there a way to convert a string number into number number?? TTM

Thanks for quick response. {table.StringIDnumber} is a numeric string. IsNumeric function gives error of requiring a number. That is exactly what I want - to convert the string into number. I kept part of mine and tried part of yours: if (toNumber({table.StringIDnumber})mod 111111111) = 0 then...

CRXI; WIN XP Trying to change a number string to number in order to calculate: if (toNumber({table.stringIDnumber})mod 111111111 =0)then ({table.stringIDnumber} else "-1" gave "The string is non-number" error, why and how to fix? TTM

WINXP, CRXI I am trying to plot XY chart where both X, Y are columns. My plot right now is: For each record {Table.X} Show values {Table.X}, {Table.Y} I gave me the correct plot but making each (X,Y) point as a separate serie so that I cannot put a regression line on. Anyone has any idea how...

I think I am getting close but not quite. (Not try the average subreport yet) The grouping seems to be working but it is still on seperate page. This is how it groups now: GH1 :Site GH2 :{@GRP}+ subreport (coulmn is {table.Unit} GH3 : Unit (need to show, cannot suppress) Detail: suppressed...

Repeating the total (oh! sorry, it is an average, not total, would that matters?)on each wrap is not a problem. TTM

LB, I am interested in wrapping the table and make it presentable. The column heading came from a field that is not sequential plus I want the total on the left (column before the first field column), not the last column. Please explain in more detail. Thanks a million. TTM

Thanks k and LB for quick response. k: sorry I am not clear on my point. I do not want to print/shrink to one page, it will still look awkward with a "wide" table having huge blank space below the table. LB: that might work but I do need a row total, so that is out too. No other ways around...

WINXP, CRXI I have a crosstab table with variable columns some over 20 columns but only 5 rows (fixed). The table spans several pages with huge blank space below the table. Is there a way to show/print this table on same page? I tried pivot it, but it still takes several pages. This is what I...

I must be missing somthing. If I put %unitDone in GF2, it only shows that single unit with one big fat bar chart drill down to data. I now put it in GF1 so that it shows all individual units in one graph under the same site (group1). I have to put %siteDone in REPORT FOOTER because I want to...

CRXI, WinXP same project as thread766-1151056 Report layout: Group 1: Site Group 2: Unit Group 3: Serial number Group 4: @monthString Detail suppressed: @monthString, @findSerialNull (//{@findSerialNull}: if isnull({Command.Date / Time}) or not({Command.Date / Time} in...

Hope everyone has a good holiday. I am not sure if my thread had no reply because of the holiday or because I was not clear on my question. In either case, please reply so I will repost the question else where. Thanks. TTM

I have a form with main chart and subform charts on detail section of several tab pages of the same form. There are parameters on the form header: Start Date, End Date, Choose Unit in text boxes. The chart x-axis is Date (between Start Date and End Date) and y-axis is some numeric values. Sample...

Thanks synapsevampire. I could not get rid of the first page with the fause group 1 even after trying out page before and page after on various header and footer. However, I use your sum({table.field},{table.group2field}) and also added count({table.field2},{table.group2field})to calculate the %...