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 Rhinorhino 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: *

  1. jlhart76

    XML & Leading Zeroes

    Not sure if this is an XML or Excel question, but hopefully someone can help. We get a file in XML every month, which strips the leading zeroes from our 9-digit ID number. So we have to re-format to add back in the 0s. We've tried all the regular tricks (using Custom Format, formatting to text...
  2. jlhart76

    Crystal 11 graphs - Layout

    Using Crystal 11 I have a pie chart with the name & value labels. The labels are just a fraction too high, where they're printing inside the graph, so I'm trying to move them. However, when I move them, they jump all over the place. Moving them marginally up, they jump down to the bottom left...
  3. jlhart76

    Subreports repeating

    It worked. Thanks, lbass!
  4. jlhart76

    Subreports repeating

    Using Crystal XI, pulling data from Access 2003. I have a report created with 9 subreports inserted into the detail section, each subreport is a single page. Data covers July - Dec 2006. Pages 1-9 are subreports 1-9, then pages 10-18 are repeats of 1-9, as are pages 19-27, 28-36, 37-45, & 46-54...
  5. jlhart76

    Excel - formula showing instead of value

    Thanks, already tried that. Anything else?
  6. jlhart76

    Excel - formula showing instead of value

    Using Excel 2003 Usually when you put in a formula, the value result shows up on screen. I have a workbook with multiple worksheets & a lot of formulas. I'm trying to insert new formulas to show values from other sheets on one sheet. Ex: on Sheet1 cell A1 the formula is "=Sheet2!A1", cell A2...
  7. jlhart76

    Count based on age

    Please see original post. Need to calculate how many are age 80+. ex: Name Age (calculated from birthdate) Bob 75 Joe 80 Tom 79 Jane 84 Ann 81 Donna 72 Total # is 6 # aged 80+ is 3 Therefore, 50% are aged 80+
  8. jlhart76

    Count based on age

    Did it, but now total # is the same as the # that are 80+, so # that are 80+ shows up as 100%.
  9. jlhart76

    Count based on age

    I'm using Crystal XI. In my database, I have fields {LName}, {FName} & {Birthdate}. Using these, I need to calculate how many are age 80 or greater. Thanks in advance.
  10. jlhart76

    Combining Publisher Documents

    Using Publisher 2003. How do I combine 2 publisher documents into one?
  11. jlhart76

    Renaming fields in graph

    Sorry, I'm using Crystal 8.0
  12. jlhart76

    Renaming fields in graph

    I have a graph, pulling data from Access. The fields used are named fldAreaI, fldAreaII, fldAreaIII, etc. When I create a graph, the labels show up as fldAreaI, etc. Is there a way to create a formula that renames them to "Area I Total", "Area II Total", etc.? Additionally, I have another graph...
  13. jlhart76

    Formula for FY calculations

    I have a report with 12-month rolling data. I need a formula to calculate the average # consumers for the fiscal year while still showing data for 12 months. (average the number of consumers if the date is July 1 or later).
  14. jlhart76

    Rounding numbers in formula

    Worked perfectly! Thanks, you're a peach!
  15. jlhart76

    Rounding numbers in formula

    I have a report that calculates the percentage meeting certain elements using the formula: if DENOMINATOR=0 then "N/A" else totext (PERCENT)*100 I want to round the number to a 0.1 digit, but using truncate or round command gives me a whole number [11.73 is rounded to 11.0] Is there another...
  16. jlhart76

    Graphs-Omitting N/A values

    I'm working on graphs for a number of reports, & several have N/A values associated with the elements. At present, my line graphs show N/A values as 0. Can I create a graph that omits N/A values by leaving a blank space for that month?
  17. jlhart76

    12-Month Running Total

    Thank you so much! It worked perfectly.
  18. jlhart76

    12-Month Running Total

    Sorry, I forget to be specific when asking for help. Data is entered on last day of month for totals for that specific month. Reports are then run for last full 12 month period. Thanks so much to both of you for your quick replies. I appreciate it.
  19. jlhart76

    12-Month Running Total

    I have 20+ reports that are run each month, most are updated to show the most current 12-month span. Instead of changing the span on each report, can I automate it to only list the last 12 months? Also, these reports list the timeframe in the page header & in a graph. Can I automate these to...
  20. jlhart76

    Simple If/Then Statement

    I'm trying to create an if/then statement, but am having trouble. The fields are: A = Total # of consumers during month B = Total # of consumers meeting criteria X I need a statement that says if A=0, then return a value of "N/A". Otherwise, divide B from A. I've tried several different ways...

Part and Inventory Search

Back
Top