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!

Register Log in
  • Congratulations strongm 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: helphelen
  • Content: Threads
  • Order by date
  1. helphelen

    Need to calculate total days less weekends

    Hello, I am creating a report in Crystal Reports 2008 that calculates the total amount of dates it took an employee to complete a task. I have a start date and an end date. I have used the "Order Process Time" formula to calculate total days lapsed; however, this includes weekends. How do I...
  2. helphelen

    Consistent colors in a pie chart

    I am working on Crystal 2008 and have multiple pie charts in my report. The report is total spending by vendor by month. Is there any way to pre-set the pie-chart color per vendor? In other words, I would like vendor X to be represented by the same color each month without having to make...
  3. helphelen

    Creating a formula with a blank field

    Hello - I would like to create an 'if' formula with a blank field. Meaning, if({employee})= "blank" then = "No" else... How do I properly convey this idea. Thanks!
  4. helphelen

    Auto-refresh

    Hello! I created a report of all our POs, organized by PO #. We create POs on a daily basis therefore the data is constantly changing. Am I able to set an automatic daily auto-refresh on my report? This would be a great help. Thanks!
  5. helphelen

    Crystal is crashing with one report

    Hello- I created a very basic report twice now and for some reason this report alone keeps on crashing mt Crystal with the warning message "crw32.exe has encountered a problem and needs to close". I am not sure if I am doing anything wrong within the report, it looks fine to me. I am able to...
  6. helphelen

    reformatting data in a table

    Good afternoon - I have a table with dollar amounts in it that is for some reason being recognized as text. I am therefore unable to insert a summary and calculate the SUM because that option is unavailable to me. Is there any way to formal the data for it to be recognized as a number?

Part and Inventory Search

Back
Top