Hello,

I have an issue and I would like to know how to handle this.

There are certain paymnets that are taken at bank and the transactions are like this

Date                 Tran#    AcctType  site # amount

10/12/2006          100       Sav           2      $120.00

10/12/2006          200       chk           3      $140.00

1/12/2007           156        sav            1       $128.00

Iam trying to retrieve all transaction for 10/12/2006.

The date is in table A

Tran# and Amount are in table B

Table C has two columns called Name and value which save all misc details like location type, account type and the site# etc.

Table C is like this.

Tran#   Name    Value

100   Acct_type   Chk

200   Acct_type   sav

100    site        2

100    site        3

and so on

In the select expert

I mentioned

Table A.date = {?enter_date} and

Table C.name in ["acct_type","site"]

The report design has the formula for acct type and site# as

{@acct_type}

is

If {table C.name} ="acct_type" then {table C.value}

{@site}

is

If {table C.name} ="site" then {table C.value}

when I enter date as 10/12/2006 the report preview is

Date           Tran#    AcctType   site#  amount

10/12/2006     100       Sav                       $120.00

10/12/2006                                     2      $120.00

10/12/2006      200      chk             3      $140.00

10/12/2006                                    3      $140.00

There are only two transactions. My expected result is

Date                 Tran#    acct Type  site # amount

10/12/2006          100       Sav         2      $120.00

10/12/2006          200       chk         3      $140.00

Basically the site # has to be beside the acct type instead of coming up as a new transaction.

Can you tell me if there are changes that need to be made in the select expert to retrieve the required result.