Hopefully a simple question

[jtktoby99]

I am completely new to Crystal Reports and am stumped on my first project. Basically what I need to do is find all account numbers that have a record with a transaction type of FA and dollar amount of 10. Then show all records for that account number.

I can get it to show me all the records that meet the criteria (FA and 10) but not the rest of the transactions for that account number. Thanks in advance for your help.

 

[KKond]

can u clarify what u want to see on the report.when u say FA and 10 then u can show only those records which match them

 

[lbass]

Remove the criteria from the record selection formula and instead insert a group on {table.acctno} and then create a formula like {@meetscrit} for the detail section:

if {table.transactiontype} = "FA" and
{table.amount} = 10 then 1 else 0

Then go to report->edit selection formula->GROUP and enter:

sum({@meetscrit},{table.acctno}) > 0

-LB

 

[jtktoby99]

Thanks for the quick replies. To clarify, in my report I want to see all of the transactions for a card number when that card number has at least one instance of a transaction type FA with a dollar amount of 10.

 

[lbass]

My solution will work--I don't know what card number is, but that should be your group field. Use it instead of {table.acctno} in the formula above. Of course you have to substitute your exact field names for transaction type and amount also.

-LB

 

[jtktoby99]

That worked. I was able to get what I needed out of the report……thanks a lot for the help.