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 wOOdy-Soft 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 Monkey820
-
if any are fail then fail
Works GREAT!!! Thank you soooo Much!- Monkey820
- Post #7
- Forum: Business Objects: Crystal Reports 1 Formulas
-
if any are fail then fail
I am not able to make it work. I am having a problem with nulls. If it is null it needs to fail. The values are null, 0.00 and 1.00.- Monkey820
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
if any are fail then fail
one field INSPECTION SAMPLE SEQ PASS/FAIL visual inspection 1 pass visual inspection 2 fail dimensional inspection 1 pass dimensional inspection 2 pass- Monkey820
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
if any are fail then fail
Hi, I need a formula placed in my group header that says "Pass" or "Fail" when looking at the details. But, I want it to "Pass" if all attributes in the details = "Pass" and "Fail" if any of the attributes in the details = "Fail". Any help is appreciated. Thanks, CWR 11.0.0.1282- Monkey820
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
percentage difference
Perfect! Thank you! Thank you!!- Monkey820
- Post #6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
percentage difference
and .... I need to format the value ex: 10%- Monkey820
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
percentage difference
I need to know the percentage {Table.Avgcost} difference from {Table.Stdcost} per itemnumber and if the percentage is over 10% to change the font color to red. This is a detail line item.- Monkey820
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
percentage difference
Hi! I need to show the difference between 2 values in percentage. I have been away from crystal for a while and am feeling lost. Any help appreciated. Thanks- Monkey820
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Value 0 gives percentage error
Absolutely Perfect! Thank you!- Monkey820
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Value 0 gives percentage error
If the {table.GOOD_PTS} value is 0, I get a "Division by zero" error. What formula should I use to consider this possiblity? I want to see a percentage but there will be some values of 0 in the report and, of course, I do not need to calculate them. But the other values in the report will need...- Monkey820
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Keyboard Input
An app with an embedded viewer- Monkey820
- Post #6
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Keyboard Input
No, it would be in the case the address differs from what we have on our ERP system.- Monkey820
- Post #4
- Forum: Business Objects: Crystal Reports 4 Other topics
-
How do I enter a "return" line in a text string?
Absolutely perfect! Thank you so much! I love this site!- Monkey820
- Post #4
- Forum: Business Objects: Crystal Reports 4 Other topics
-
How do I enter a "return" line in a text string?
I am trying to arrange fields in a formula: if {table.FOB} = "COLLECT" then {@shipto} I need the {@shipto} formula to list the {table.ATTN}, {table.ADD1}, {table.ADD2}, etc. in a properly lined order such as: Attn: Company Address1 Address2 City, State Zipcode TIA for any suggestions! Micky...- Monkey820
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Keyboard Input
Is there any way to add a prompted field for the user to keyboard input their own address information on a report? Any help is appreciated! Thanks, Micky WinXP CRW 8.5- Monkey820
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 4 Other topics
