two tables to be used in a single r

[kalpsv]

two tables to be used in a single report

i have a table called citymaster with citycode and city name
as fields
i have another called statemaster with statecode and state name as fields
i have a transaction file which is including all the transaction like receipts and payments.
i want a report which is grouped by date on city and state code.
in one state i have a city code also. the data which is said to be retrieved is city txn and that state txn less the city txn.

i get both together. since i have various other states i am unable to bifurcate.
kindly help me
bye

 

[MVisconte]

I understood it all up until

> in one state i have a city code also. the data which
> is said to be retrieved is city txn and that state
> txn less the city txn.

A clearer explanation, or perhaps examples would probably help.

> i get both together. since i have various other states
> i am unable to bifurcate.

Now that my children are getting older, I am a firm believer that one should not bifurcate until after marriage. ;-)
Waiting makes bifurcating that much more special.