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

    calculating dates when suppressing records

    awesome thank you!! now I was thrown a curve which I hope can be corrected easily with this is there a way to do a count on the records so they can see how many were done "on first record" and the previous record?
  2. timISST

    calculating dates when suppressing records

    Ok it works awesome thank you for that the only issue I have and here is my formula is the second date comes out as a negative number can you tell why? If onfirstrecord or ({Name})<> previous({Name}) then Currentdate-{data.Data_Entry_Date} else...
  3. timISST

    calculating dates when suppressing records

    What I meant to say was the crred control cannt be applied separately to the 2 results?
  4. timISST

    calculating dates when suppressing records

    so to make sure I'm understanding you right ( and thank you) theres no way to do the cr formatting on each one separately? ie the number of days between the 1st and second date isn't > the no of days?
  5. 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...
  6. timISST

    Replace &amp; 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?
  7. timISST

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

    I did a little testing and the subreport section is what is generating my blank pages. All the sections of the subreport are suppressed ( no drill down) the subreport itself is formatted to suppess blank subreport and all the sections ( except the one the subreport is in are suppressed if Count...
  8. timISST

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

    Hi I went and looked at what you suggested and this is how it is set up but it still generates a blank page for a record that doesnt meet the criteria.
  9. 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...
  10. 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...
  11. timISST

    I have a form that the user answers

    I tried using this to set the question to 0 but nothing happened. IF x = '1' then '0' else if x='2' then '0' else if x='3' then '0' else to number y that didnt do anything either.
  12. 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...
  13. 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...
  14. 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?
  15. 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...
  16. timISST

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

    I made formulas to lay out like filler fields and such where they may not be data present but the spacing has to be. The issue Im having is I need all the fields touching as to not create undo and unwanted spaces in the report at suggestions?
  17. timISST

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

    should have added that im using a lot of formulas in this in case that makes a difference
  18. timISST

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

    Is there a way to designate field lengths? all of this is a report that has fields that may or may not have data and filler fields that have to be there to be read by the recieveing party? The zero filled ones I have figured out the blanks I think I know what im doing but wasnt sure if there was...

Part and Inventory Search

Back
Top