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 derfloh 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: Charley71
  • Content: Threads
  • Order by date
  1. Charley71

    Help displaying all bins on a chart

    I have a chart that on of the axis is based off a formula called buckets that looks like this: if {@megs} < .10 then "0.00 to 0.10" else if {@megs} < .50 then "0.11 to 0.50" else if {@megs} < .69 then "0.51 to 0.69" else if {@megs} < .99 then "0.70 to 0.99" else if {@megs} < 1.5 then "1.0 to...
  2. Charley71

    Sum based on condition

    I can't seem to get a summary to work the way I need it to. Seems like it should be easy but it isn't working for me. I basically just need the following if ({provider})="nPhase" then sum({totalmegs}); This needs to sum for the entire report. What am I missing?-thanks
  3. Charley71

    Help Grouping based on conditions of a field

    I am having trouble getting a report to group sections based on conditions that I set. I think I just don't know how to do this and am hoping it is easy. I want to have my report tell me how many accounts fall within a range of usage based on megabytes. For example: I have two fields on my...
  4. Charley71

    date formula that will total up hours

    Here is my dilema-this is an export from a third party software package that is a .csv which I changed to a .xls. The cells contain this data (all in one column) looks like this: (example) 1 day 00:02:07 1 day 01:00:57 1 mon 10 days 03:12:16 If I use crystal to report against this worksheet...
  5. Charley71

    Date conversion to hh:mm:ss in Excel

    Is there a quick way to convert this: 1 day 00:02:07 1 day 01:00:57 1 mon 10 days 03:12:16 1 day 00:03:01 1 day 00:06:30 to hh:mm:ss Thanks
  6. Charley71

    Moving data from one worksheet to another using formula

    I don't know if this is possible but I would like to populate a second worksheet with data from c1 where a1:a500="A". I know this formula will get me one record and if I drag it down, I will get a bunch of "False" then a record. I know why that is happening but how can I get it to just display...
  7. Charley71

    Trouble evaluating time

    I have a report that looks like this: Wilson, Ted 10/19/07 9:26 am 10/19/07 10:56 am 10/21/07 8:00 am 10/21/07 8:50 am and so on. What I need to do is evaluate the time difference for every 2 records. I would also like to be able to have a label that will say "On Time" for the lower...
  8. Charley71

    How do you display the top 10 values

    I have a report that will show a variety of information. This is coming from a spreadsheet. I have 15 rows of data with a count for each field. Column A=Inspection and Column B=count. I want to create a chart with only the top 10 inspections. Is there a way to display only the top 10? (this...
  9. Charley71

    Counting Formula not Working

    I am having trouble getting this formula to return a count. Can someone tell me what might be wrong with it. I am using crystal version 11 developer. if (GroupName ({@monthname})="January") then count({Gprsfware.SCID}) I need it to count all the records for field SCID that were added in the...
  10. Charley71

    help counting based on parameters

    I need a formula that will count occurances of records that are between number ranges within a group. For Example: if (table.fieldname)>=1 and <=3 then count (table.fieldname) I am just unsure of the syntax. I am trying to create 6 "bins" of data so I can have an accurate histogram. I'm a...
  11. Charley71

    Importing .csv large number into Access Table

    I need to import a very large file into an Access database. I am using the file to create the table. One of the fields contains a number that is very long and will only import it as scientific notation. No matter what I do with the .csv file or the format of the field in Access it will not...
  12. Charley71

    Breaking apart a string of data

    I need to split up a field into sections to have it print under the appropriate labels. The field is called: Accountno The number consists of 8 sections, one of which is always blank. So if my number is: G530-97090-27-051-501-031 I would need to break it apart and have it print under the...
  13. Charley71

    Would like to Not Print duplicate details

    I have a report I am working on that is printing the details multiple times if there are mulitple items for on field. For example: This is what it looks like because there are two buses on this report: (crystal reports XI) Group 1: TripID Details A: TripDate Destination # of Buses Details...
  14. Charley71

    adding boxes to a report that will grow based on another field

    I have a field in a database called "buses", this is a numeric field. Based on the number in that field, I want an empty box added to the report. Example: The number in "Buses" is=2 there will be two boxes printed below it, if there are 3 buses, there will be three buses printed below it. Does...
  15. Charley71

    Help pulling last two dates in a group

    I am trying to pull out the last two dates in a column of dates and subract them from each other. For example: Work Date 1/1/2007 1/23/2007 3/4/2007 8/15/2007 I would like to be able to take the last two dates and subtract them to get a number of days. so 8/15/2007-3/4/2007. I would also...

Part and Inventory Search

Back
Top