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

    calculating dates when suppressing records

    Making a report that I have set up group by client then dates are sorted decending and I have the section suppress if the count is greater than 3 so I get the last 3 records. that works fine. My issue is I need to be able to calculate ( todays date - the newest records date), the newest records...
  2. timISST

    Replace & with a blank

    I have a report that is pulling fields from dictionaries so when the data is showing it has &What& and I'd like it to just print as What. Any ideas on how to convert it?
  3. timISST

    how to suppress blank pages in a report that the subreport is controlling the data collected?

    I have a report that the data collected is driven by the subreport. The report looks like this detail A is the subreport Detail B is the data to be displayed based on the subreport returning a value of 1 any other result is to be ignored I can suppress this based on subreport <>1 Group footer...
  4. timISST

    date field question

    I have a report that is looking at field "a" ( a date field) for data. Field A initially is blank but when it gets populated and the report is reran it give me 2 pages 1 with the field blank and 1 with the field populated any ideas how I can eliminate the blank field page? as a side note I do...
  5. timISST

    I have a form that the user answers

    I have a form that the user answers 1 question (x) or the other (y) and the one they dont answer gets disabled. I have that working. here is my issue I am making a report that calculates an average and I cannot figure out how to make the report ignore the disabled field. any help would be...
  6. timISST

    conditional formatting in group footer and report footer

    trying to do conditional color font on group footer and report footer. These are average fields. I was able to get the fields in the details to conditional color code the way I would like but have not been able to figure out how to do that in the footers. This is how I'm doing the formatting in...
  7. timISST

    Average

    I have a report that looks similiar to this customer date field1 field 2 field 3 it will have new dates with the fields reoccuring what I need to be able to do is have an average showing at the bottom of each field. I was thinking i need to do a group by date but wasnt sure any suggestions?
  8. timISST

    I have this report Group Customer

    I have this report Group Customer with subgroup order number and what i am trying to do is filter this so it will only show a customer that has an item occuring more than 1 time in a given order ( checking for order entry errors. IE Customer 5 Order 1 Item a Item B Item A Item C I want the...
  9. timISST

    error with formula to zero fill a field if no data is present

    IF (ISNULL({date)) = TRUE then "00000000" else {date}; Gives me the error of a string is expected here at the second date ( they are date fields) tried converting to str and when i did that it gives me the bolean str number date error. Any ideas?
  10. timISST

    convert ss# xxx-xx-xxxx to xxxxxxxxx in crystal

    have tried several things to no avail any ideas?
  11. timISST

    Need to print record for last 3 dates based on criteria

    I ahve been trying to get this to work based on a start and end date (Past 5 working days) the report needs to show the following Last 3 dates it happened for J when 6/16/12 Y 6/1/12 Y 5/15/12 y show J or if 1 of the 3 comes back N then do not print any ideas
  12. timISST

    display only 3 most recent records

    I have a report that is grouped by person and I need to show there 3 most current dates. It also needs to eliminate people with LESS than 3 dates.I am using Crystal 2008. Example would be John Smith: 6/6/12 5/3/12 2/7/12 Thanks!

Part and Inventory Search

Back
Top