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!

Recent content by Yeseniah

  1. Yeseniah

    Exporting to Excel - Extra Rows Created

    Make sure all the sections not needed(such as Group Footer) is suppressed. You can do this in Design section of report, just right click section and select Supress.
  2. Yeseniah

    Formatting Field in Crystal 8.5

    Thank you kskid! I did have this suppressed and your solution works perfectly! Thanks! Yesenia
  3. Yeseniah

    Formatting Field in Crystal 8.5

    MrBill, I appreciate your help and tried the formula you suggested, however it is still pulling amounts for amounts other than current month. Ex. I got amounts for deposits expected in Nov. & Dec. Do you know why that could be? Thank you. Yesenia
  4. Yeseniah

    Formatting Field in Crystal 8.5

    Yes, need to check for year as well. Is this the correct selection for that? Thank you. Yesenia
  5. Yeseniah

    Formatting Field in Crystal 8.5

    Hi. I would like to format a field so that it only prints amounts for money expected in the current month. I have the following formula in the "Suppress" section of the Format Editor: //Only show amounts for $$ expected in current month If Month({TEMPUS_OPP.DEPOSIT_ORIG_DATE}) =...
  6. Yeseniah

    Report on Null Values

    THANKS so much!! Works perfect! :o) Yesenia
  7. Yeseniah

    Report on Null Values

    Picklist was so that I was only looking at open tickets, however took that out to test formula... isnull({TICKETACTIVITY.COMPLETEDDATE}) and {TICKETACTIVITY.ASSIGNEDDATE} < CurrentDate This gave me a report with no data. I'm testing the report and made a point to enter a record with missing...
  8. Yeseniah

    Report on Null Values

    Hi. I would like to run a report that pulls all the records that do not have any data. To be more specific, I am running a report on user activities, for those that were assigned a date prior to current date AND do not have a complete date in {COMPLETEDATE} field, I would like to see the...

Part and Inventory Search

Back
Top