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

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

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

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?

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

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?

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