Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tektipsMem
  • Content: Threads
  • Order by date
  1. tektipsMem

    toNumber({table.stringIDnumber}) give error "string is non-numeric"

    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
  2. tektipsMem

    XY chart column as series, add regression line, how?

    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...
  3. tektipsMem

    Show crosstab with lots of column but few rows in same page

    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...
  4. tektipsMem

    Drill down chart, how?

    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...
  5. tektipsMem

    Dynamic change subform chart on tab pages by parameter

    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...
  6. tektipsMem

    Total count and percent total on page header possible?

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

    Left outer joint not showing correctly

    Hi guys, I am using Crystal Repoort XI. I have two tables joint by left outer joint, enforced from and joint type "=". Here's what shows in SQL SELECT `UN2005`.`Date / Time`, `Meters`.`Site`, `Meters`.`Unit`, `Meters`.`Date returned`, `UN2005`.`Meter Serial`, `UN2005`.`Result`...

Part and Inventory Search

Back
Top