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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by edison1135

  1. edison1135

    Inserting new document into Word

    After you place your cursor at the very end of the existing document, insert a section break by selecting Insert, then Section Break/Next Page. Now try inserting the new material here and it should be OK. You may need to deselect the "Same as Previous" button in Headers compete with...
  2. edison1135

    Dollar breakout by month depending on duration

    Thanks - I'll definitely take a look at your solution and let you know how I made out. Edison1135
  3. edison1135

    Dollar breakout by month depending on duration

    I'm using Crystal Reports 7.0 to pull data from an Access database. The fields involved are: Lead Number Start Date Dollar Total Years Duration The user would like a report that allocates the total amount evenly accross the months included as determined by considering the start date and the...
  4. edison1135

    CUMULATIVE CHART QUESTION

    Ken, Thanks for the quick reply - I gave you a star. I changed the date ranges to include the previous quarters, but it still doesn't report cumulative amounts. I believe the Q1Count formula only assigns a label to the chart, but I could be wrong. My chart is built on the following...
  5. edison1135

    CUMULATIVE CHART QUESTION

    I think I must be missing something simple here, but I'm having trouble figuring out how to build a line graph that shows the cumulative dollar total by quarter. I would also like a second line graph in the same chart showing the cumulative pipeline remaining by quarter. I'm using Crystal 7.0...
  6. edison1135

    Save Results as Text on the report

    Thanks for the reply, but I don't believe this will work for my situation, because for some of the categories I'm tracking, if I run a report in February, then re-run the same report later in the year trying to recreate the February information, it will have changed. Won, Lost and No-Bids will...
  7. edison1135

    Save Results as Text on the report

    Ido, Could you include an example or elaborate further about using a subreport to return the cumulative figures for each month via a shared variable? My report is grouped by category; Won, Lost, No-Bid, etc, and I run it each month. This way I have a snap-shot picture of the numbers at...
  8. edison1135

    Save Results as Text on the report

    Thank You very much for the quick reply. I'll give it a try. Edison1135
  9. edison1135

    Save Results as Text on the report

    I'm using Crystal Reports 7 to write reports against an Access Database. One of the monthly reports gives me the number of Cumulative wins for the year, the number of Cumulative Loses for the year, and so on for the various categories we track. I use the 3 formula running total method...
  10. edison1135

    Printing a Formula

    Thanks Ken, Is there anyway to write an instruction to a report that will automatically print the contents of all associated formulas?
  11. edison1135

    Printing a Formula

    How can I print the contents (the actual equation) of a formula in a report?
  12. edison1135

    Printing a Formula

    Please disregard this question. I posted it in the wrong forum.
  13. edison1135

    Printing a Formula

    How can I display a formula in a report? I want to show the equations, ifs, thens and elses.
  14. edison1135

    Display Message at Group Header if Blank

    I tried adding a subreport for the manager with no activity for the period. No wins, no losses, no activity. Is there any way based on that condition, to display a message stating there was no activity? Thanks
  15. edison1135

    Display Message at Group Header if Blank

    I'm using Crystal Reports 7 with a MDB database. I have a report that is grouped on Marketing Managers, and the report lists the wins for each manager. If a Manager had no wins for the period, his/her name is not displayed. I want to be able to add a stagement which will automatically display...

Part and Inventory Search

Back
Top