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

    Charting Print-Time Reports - monthly values not accumulating

    I'm back. Please don't give up on me. I'm helping someone with this report so that they can do the graphing they want to do. They were using the following formula to retrieve both the month and the amount. NovMnt she was told to always check if enc_close_date is null.in the first part. The...
  2. DESTINEEJSH

    Charting Print-Time Reports - monthly values not accumulating

    The goal of the whole report is to have a graph that would show each month on the horizontal axis, and the total count for each month on the vertical axis. I am accumulating in the main report and then using the subreport for display. There shouldn't be any values in future close dates.
  3. DESTINEEJSH

    Charting Print-Time Reports - monthly values not accumulating

    I've included WhilePrintingRecords in all of my Count Formulas. As our Fiscal year is July to June, I'm expecting January through June to be blank. I do expect counts in my formulas for July through November. I'm still getting blank values. As I said before, I'm totaling my counts in the...
  4. DESTINEEJSH

    Charting Print-Time Reports - monthly values not accumulating

    Hello everyone in the Tek-Tips Forums. I need help with the following scenario: We need to calculate the amount of contacts that closed for all patients each month based on a formula. So January isn't necessarily Jan 1 - Jan 30. Also when we run February, we want January to hold the value it...
  5. DESTINEEJSH

    Arrays not displaying Values - want to use in Chart

    We've tried creating a formula for each month that just holds the Month Name. For instance, M-Jan = "Jan". Then we run the above formulas for counting as each months counts in individual formulas. Our problem is our lack of experience with charting. We don't know where to go from here to...
  6. DESTINEEJSH

    Arrays not displaying Values - want to use in Chart

    We need to calculate each month based on a formula. So January isn't necessarily Jan 1 - Jan 30. Also when we run February, we want January to hold the value it held when it was run in January. The same would be true for March, we would like Jan and Feb to hold the same values they had when...
  7. DESTINEEJSH

    Problem with Join between 5 tables - tables described at bottom

    Sorry about that, I forgot the database. It's SQL Server 2000. Deb S.
  8. DESTINEEJSH

    Problem with Join between 5 tables - tables described at bottom

    Crystal 9.0 Prtime is the driving program. Budget may have a value in it, but not a corresponding record in Prtime. Currently all joins are set as Inner Joins, except the join between PayPd and Budget. I want all Budget records to display, even if there isn’t a corresponding record in...

Part and Inventory Search

Back
Top