Recent content by jlhart76

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

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

It worked. Thanks, lbass!

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

Thanks, already tried that. Anything else?

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

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+

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

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.

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

Sorry, I'm using Crystal 8.0

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

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

Worked perfectly! Thanks, you're a peach!

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