Search results for query: *

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

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?

Thank you so much! It worked perfectly.

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.

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

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