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: *

  1. davismar

    Crystal Reports - Report blank after entering 2 parameters and tables not showing all data

    I have a Crystal Report in which I have (2) dynamic parameters created: ItemID (this is a string using list of values = static) Serial Number (this is a string using list of values = static) The user will enter and Item# and it's corresponding serial number, which will then...
  2. davismar

    SQL Statement to copy value from field1 to field2 then clear data in field 2

    Thank you, Thank you so much! That worked perfectly! If I did want to add a WHERE clause, what would that look like? For example, where ACCOUNTTYPE = CSA Customer Another question: Would you know how I can then do the following: Copy the data from the ACCOUNTNAME to the ARCustomerNumber...
  3. davismar

    SQL Statement to copy value from field1 to field2 then clear data in field 2

    Thanks to whomever might have this SQL statement for me to try! [2thumbsup] The table name is ACCOUNTS. Field 1 = ARCustomerNumber Field 2 = AccountID We would like a SQL statement that will 1. Clear the data from Field 2 ACCOUNTID 2. Copy the data from Field 1 ARCUSTOMERNUMBER into Field 2...
  4. davismar

    Extract results and text values from a memo field Crystal Reports XI

    Hi! [santa3] Can anyone help me strip out some results / text values from a memo field in Crystal Reports XI? {tvw_JournalNotes.Notes} One result returns: Made Call: (I want to eliminate any of these results) Second result returns: *Series...." (I want to eliminate any of these results) I...
  5. davismar

    Image field and displaying Y or N after testing for null values

    Hi! I have an image field that I would like to add to a report. Basically, if the image field contains a signature, I would like to have a column that says Y for yes. But if the image doesn't have any data, I would like the column to say N for no. Would anyone be ale to help me with this...
  6. davismar

    Past Due Invoice Report

    [lipstick]Pete, YES! That was the fix that I needed. The report works great now. Thank you VERY much for your help. I really appreciate your taking time to help me out. I'm giving you a STAR!
  7. davismar

    Past Due Invoice Report

    I sincerely apologize....you are right. My work has been stressful and I often get caught up in fixing things...without taking time to thank many of you. Again...I AM VERY SORRY. I will be more conscious of my actions going forward.
  8. davismar

    Past Due Invoice Report

    This is a start, but I'm showing all invoices with prior dates. Therefore, it appears the formula is giving me all invoices. I believe I need to do something with the @AgingBracket2 formula also? @AgingBracket2 FORMULA: if {@Age} > 7 and {@Age} < 20000 then {@AmountRemaining}
  9. davismar

    Past Due Invoice Report

    I need some help with a Past Due Invoice report. The current report is based upon any invoices with an AGE greater than 30 days. Here is the info I have currently: @AGE FORMULA: datediff("d", {JrnlHdr.TransactionDate}, CurrentDate) @AgingBracket2 FORMULA: if {@Age} > 7 and {@Age} < 20000 then...
  10. davismar

    Crystal Reports - Date Range Help

    thread767-1450985 In Crystal Reports XI: I'm trying to get a list of accounts for which there has been no activity over the past 2 years - based upon a task start date. Ideally, I need a list of these accounts/customers so we can have someone begin calling on them. The specific data field...
  11. davismar

    Bi-Weekly Payroll Hours Report Formula Help

    I have a bi-weekly payroll hours report, that currently 1 grand total of all hours per employee for the 2 week period. It also has a total of hours for each day. I need to sum the totals for week 1 and week 2. Also, I need to combine the type of timelogs by Regular, Overtime, Vacation and...
  12. davismar

    Formula help and summing based on string true or false.

    Thank you! No hurry - just wanted to make sure you received it. I very much appreciate the help! MD
  13. davismar

    Formula help and summing based on string true or false.

    Dell, I emailed you a copy of the CR with saved data and a .PDF with 1 page of the report to show you what is being displayed. Thanks!
  14. davismar

    Formula help and summing based on string true or false.

    Dell, I emailed you a copy of the CR with saved data and a .PDF with 1 page of the report to show you what is being displayed. Thanks!
  15. davismar

    Formula help and summing based on string true or false.

    Yes - so I performed all of the above, but there are still blank records. Also, the field names in Group Header 1 on the subreport are not displayed when "Password Changed" is populated. Any other ideas?
  16. davismar

    Formula help and summing based on string true or false.

    Dell - That worked perfectly. You are my new best friend! [2thumbsup] Now for the final questions- I promise: For the Subreport 1. Report Header B - How do I suppress the field headings for all results other than "Password changed? 2. Detail Section - How do I remove the space for...
  17. davismar

    Formula help and summing based on string true or false.

    I just need to show the password change row but I need to make sure by doing so, that the count formulas still calculate properly.
  18. davismar

    Formula help and summing based on string true or false.

    Great! I added WhilePrintingRecords; to the count formulas and that worked. Almost there! So finally - the report is now 45 pages. Can I suppress the data that does not contain a time log "Password Changed" but still allow the total SO counts to calculate properly? Thanks! [thumbsup2]
  19. davismar

    Formula help and summing based on string true or false.

    Thank you for clarifying. But for some reason, the count formulas that I placed in the Report Footer of the Main Report as return 0.00 for both. Any ideas?

Part and Inventory Search

Back
Top