Select Expert

[hgg21]

Hi,
I have 2 tables in which there are some fields I want to display. These 2 tables are linked together by 3 tables which I did not display their fields.

Now, if I want to display data based on the undisplayed tables' fields. Can I do that?

OKie example:

2 Tables: Bucket and Trade
Linking tables:
Bucket-Symbol-Trade-SubProduct-Product-ParentProduct
Fields to Display:
Bucket.BucketName, Trade.ProdCredit

I need to display ProdCredit 5 times in the report when Product.Product and ParentProduct.ParentProduct have different values.

Example:
BucketName ProdCredit ProdCredit ProdCredit

How do i set the formula?
I have tried this:
If {Product.Product} = "Commission" then
{Trade.ProdCredit}
and
If {Product.Product} = "GED" then
{Trade.ProdCredit}

However it has different results when I test out the data using only BucketName and one ProdCredit only.

Please advise
Thanks and regards
Jerry

 

[dgillz]

A record selection formula must be a boolean formula, that is, it must evalaute to TRUE or FALSE. True records make it to the report, and false ones do not.

Your formula:

If {Product.Product} = "Commission" then {Trade.ProdCredit}
and If {Product.Product} = "GED" then {Trade.ProdCredit}

Does not evaluate to true or false.

You also said you want to see a certain field 5 times under a certain condition. This has absolutely nothing to do with the select expert or a record selection formula.

Please rethink what you are trying to accomplish, and repost.
Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[hgg21]

If {Product.Product} = "Commission" then {Trade.ProdCredit}

I want to display the ProdCredit for the BucketName when Product is equal to Commission. Isnt this the formula?

 

[dgillz]

This is a formula, but your post was titled "select expert". A selection formula, as generated by the select expert or manually entered, must evaluate to true or false. Your formula does not. That was the point of my response.

The formula you posted above should work fine. Is it working?

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[hgg21]

Hi,

thanks for your reply.

Well, I m not sure whether it is working or not. This is because I have 5 of these formulas in the report.

If {Product.Product} = "Commission" then {Trade.ProdCredit}
If {Product.Product} = "GED" then {Trade.ProdCredit}
If {Product.Product} = "Agency Portfolio" then {Trade.ProdCredit}
If {Product.Product} = "Convertibles" then {Trade.ProdCredit}
If {Product.Product} = "New Issue" then {Trade.ProdCredit}

Then in the select expect, I put {Product.Product} IS LIKE
"Convertibles", "Agency Portfolio" and "GED"

{ParentProduct.ParentProduct} IS LIKE "Commission" and "New Issue"

However, for the formulas for Agency Portfolio and GED, there are only zeros....which I dun think is the correct values.

Is my method correct? Can I use the select expert in this way?

Thanks for the advice as I m very new to Crystal Report.
Regards