Search results for query: *

I have figured it out...I switched to a right join...

I am reporting on 2 db tables {CLASSIFICATION} and {FACILITY}. Using a left outer join I have connected the 2 tables at {CLASSIFICATION.IND_ID} and {FACILITY.IND_ID}. The best I can tell, if no other fields are populated in the {CLASSIFICATION} table, then on {CLASSIFICATION.IND_ID} is recorded...

Will CRXI not allow me to compare one field to another? When comparing {TESTRAW.RESULT} to {@Limit}, I get the error message "The formula result must me a number".

Thanks so much for your help. I have the format in working order, however, I would like to conditional format the testraw.result. The condition being if {TESTRAW.RESULT}>{@Limit} then crred else crblack. Where do I put this formula?

As you see in the right column there is a limit (limits.limit_override), and the left is the automatic populated limit (limits.limit). If there is a value in the left column, I want to compare the test result to the limits.limit_override, if not default comparison to the right column...

Yes, again because I found that the {LIMITS.LIMIT} can be stored even when there is a {LIMITS.LIMIT_OVERRIDE} stored.

In continuing to review data, I find that there could or could not be a {LIMITS.LIMIT} set in the limits table when there is a {LIMITS.LIMIT_OVERRIDE} stored. Therefore, I guess I am trying to find if the {TESTRAW.RESULT} is greater than the {LIMITS.LIMIT_OVERRIDE} first, and if it is not...

In Crystal Reports XI, I am trying to compare sampling results {TESTRAW.RESULT} from table TESTRAW to applicable limit. The database setup is where a automated limit is populated for for each parameter - {LIMITS.LIMIT}, if there is a change the limit is stored in {LIMITS.LIMIT_OVERRIDE}, leaving...

Thank you for the suggestions, I can not get it to work properly. I am using CRXI. Is there I way that I can tell CR to pull the most recent start date? That is another way of retrieving the records I want.

I am writing a report that I am trying to pull current records into. That which makes them current is a blank end date. Is there a formula to accomadate that? I current have to following formula in the Select Expert: {POLLUTANT_L.POLLUTANT_DESC} = "Zinc, total" and...

Thank you so much! I have been working on this off and on for a week! Your suggestion worked perfectly. Thanks again!

I am fairly new to Crystal reports, table.group references what the report is currently group by?

I am trying to filter my report with the most recent effective date. When I use the formula under select expert in CRXI, {SURCHARGE_FWA_RESULTS.EFFECTIVE_DATE} = maximum {SURCHARGE_FWA_RESULTS.EFFECTIVE_DATE}, I get an error message stating "The remaining text does not appear to be a part of the...