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, 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...
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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.