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!

  • Congratulations TouchToneTommy 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: bgon1
  • Content: Threads
  • Order by date
  1. bgon1

    crosstab compare years

    thread149-1570816 Can this be done in a crosstab? I want to compare the same period in the current year vs. prior years. eg. mar 1-7 2011 mar 1-31 2010 ... 09 ...08 cust1 |------------ | ------------ cust2 | | cust3 | |...
  2. bgon1

    Help needed with charts

    Hello I am trying to do a line chart in CR9 where several years' information is shown together on the same chart for comparison purposes, but i've come across some obstacles. Data X axis is sales information summarized by month and sorted on a fiscal year end date of Aug - July. Y axis...
  3. bgon1

    CR9 Charts year over year

    How to make a chart of running totals with year over year information? I've discovered how to chart two years information on one chart thanks to Ibass. I followed this: Try using a formula for month for the "on change of" field: monthname(month({table.date})) After adding this to the...
  4. bgon1

    divide by zero

    I have been trying to run a report where some of the denominators in a formula are zero ("cannot divide by zero"). The result is that the entire report is suspended. Is there a way to tell crystal to bypass the zero values or change them to another value ie. 1? Thanks for suggestions.
  5. bgon1

    crystal 9-how to use selection for totals in cross tab?

    I have just begun using cross tabs. I have a report and want to select records that total less than a specified value. However when I choose the selection tool, the totals are not showing up as a selection source. I can choose from any data table, but not from the summaries. In a regular...

Part and Inventory Search

Back
Top