Recent content by davismar

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...

Thank you SQL Bill! Very much appreciated!

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...

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...

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...

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...

[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!

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.

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}

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...

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...

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...

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

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!

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!