Search results for query: *

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!

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?

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

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.

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]

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?