Crystal Reports and Loan Quest

[Donna6772]

We are working on a formula to generate a report of Uninsured loans. The problem we are having is Loanquest has several sub fields in the item tracking portion of the application. In the item tracking portion of the application if a loan is insured and the certificate recv'd it has the sub code "CRCD"
All of the sub fields have codes but the fomula we are using still shows loans that we know are insured. We want to take all the loans with crcd code off the report". We have wrote an if then statement but nothing seems to take the loans off that are insured. Any ideas for what kind of statement we should be making.

 

[FVTrainer]

I'm not sure what formula you are talking about. If I understand your problem correctly, you want to filter your report so that it does not inlcude records where some field (the name of which you did not mention) has a sub code of "CRCD". So, if that is the case, what you need to do is create a record selection formula that expresses that filter. From the menu, select Report | Edit Selection Formula | Record and enter a formula similar to the following (replace the sample field with your real field):

{tablename.somefield} <> &quot;CRCD&quot;

The record selection formula takes a boolean statement (something that eveluates to true/false), not a standard if..then statement.

 

[pgtek]

Hi
select the filed and from the select expert
choose

is not one of &quot;CRCD&quot;

cheers


pgtek

 

[pgtek]

Hi
select the field and from the select expert
choose

is not one of &quot;CRCD&quot;

cheers


pgtek

 

[synapsevampire]

I haven't heard the term subfield in ages, are you using an old mainframe?

Consider posting technical information (version of CR, database, example data, and expected layout) about your environment when asking for technical information.

-k