Search results for query: *

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

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

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

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

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

Hi There! I need a formula to suppress the field if the 6th character in the field equals -0-. How do I formulate it to only look at that 6th character? Any help is appreciated! Thanks! Micky CRW 8.5 WindowsXP

Hi! I need a formula to select the last 7 days of records. I have a report that will run automatically and I need it to pull the past week based on a date field. Any help is appreciated. Micky CRW 8.5 OS WinXP

I started with a report that had a chart in the Report Header. I deleted the chart and resized the Report Header (smaller). It starts the Page Header on the next page. I checked the Section Formating and the only thing that is checked is "Free-Form Placement" and "Keep Together". What else...

Can someone help me format my datetime field to be MM/dd/yyyy? and then to make a parameter for that field that is not datetime, but the same format of MM/dd/yyyy? I am using CRW 8.5 I tried ToText( {ILLM_DRT.PROD_DATE},"MM/dd/yyyy" ) and also tried ToText...

I have a subreport that produces dates for the group that meet the criteria of "bucket 1". The problem is there may be more than one date that is in "bucket 1". How do I supress all but the earliest date? TIA, Micky CRW32 8.5

What am I doing wrong? if {@Balance} < 0 then red else black or if {V_ORD_DTL_AVALIABILITY.PROMISE_DATE} < CurrentDate then red else black or if {V_ORD_DTL_AVALIABILITY.PROMISE_DATE} <= CurrentDate + 7 then Blue else black I am getting an error that a boolean is required before the 2nd...

Hi There! I have posted before but am still having the same problem of speeding up a report. I need the report to select the data on the server. I do not know how to do this. Any help will be greatly appreciated. the previous post is at...

Hi There! I have a report that takes 7-8 minutes to load bcz it is sorting through years and years of data. How can I make this report faster? I thought if I could get it to record select on the server for dates > 1/1/04, that might help, but I really don't know how to do that. Can portions of...

Hi There! I am trying to connect to both an Oracle database and an ODBC, Access Database. I can now connect to both of them but I get the error, "More than one database driver has been used in this report. If you want to change the database drivers use Database/Set Location. Also, please make...

Hi There! How can I filter numbers within the middle of the value? for example: I have these numbers: 7009-11001 7009-01001 7012-10002 7012-01003 2569-01004 2569-11001 I need to filter out only the numbers that the 6th character is greater than &quot;0&quot;. Only the 6th character should...

Hi There! Using Exchange 2000 we have filtered personal email addresses that have become a problem, yet we want to be able to filter outgoing messages to particular email addresses. Is this possible? Also, we want to be able to allow an address to be recieved by one user and not by another. Is...

I have two total fields that both are correct but need to be the same running total. The first total is a formula @Evaulate and @Display which function is not to include in the sum the value of Operator requirements when the production Hours equal 0. It reads as such: @Evaluate...

Hi There! I am trying to get accurate totals. I have a &quot;production hour&quot; field that I need to know the &quot;operator requirement&quot; value for. If the production hour value is &quot;0&quot;, then I have it supressed, but if there is a value in the &quot;operator requirement&quot...