Search results for query: *

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 %...

CR XI, WIN XP I have a total count and a percent total on group 2 footer. I like to have these value shown on the page header to make stronger impact on clients who read the report. Basic layout: Page header: report title, {Site}, {Unit}, column headings Group1 header: {Site} (hide, new page...

LB, Sorry to get back this late, thank you very much for your help. SQL Union all suggestions works fine. Thanks again. TTM

Thanks very much for your patience. Yes, I meant suppressing rows with zeros. The report is taking shape. All ten tables together have about 10,000 records. However, it takes a long time to generate the report and the record count is in the order of 5,000,000. Why? You suggested conditionally...

LB Followed exactly to insert max, but resulting report still shows 0 for serial numbers that has results, like the table I showed last time. How do I get a report which shows ONLY the serial (and count) with no results ? TTM

Thanks Madawc and LB. I have been trying LB's suggestion. Don't quite understand "insert a maximum on each formula". If I set maximum({@Jan05})=1, then all serial gave 1. Then I did maximum({@Jan05}, {table.meternumber}) and put in the serial number group footer, suppress detail. Somehow, the...