universe1 accountnum, name, cableboxnum, active(y/n)
universe2 accountnum, date, trans_amt, trans_type
Info: accounts can have multiple active or inactive
cableboxes
trans_type, "W","E","T","H"
There could be only 1 "W" type for an account
Question: How can I display the total number of active (or inactive) cableboxes on a "W" type transaction report? The account shold only list once on this report.
Something like:
Accntnum active_boxes Date trans_amt Trans_type
12345 4 06/22/03 -250.45 W
55431 2 06/22/03 -50.00 W
1. Can it be created in WEBI? How?
2. What's the easiest way in Full Client?
Thanks a bunch!
universe2 accountnum, date, trans_amt, trans_type
Info: accounts can have multiple active or inactive
cableboxes
trans_type, "W","E","T","H"
There could be only 1 "W" type for an account
Question: How can I display the total number of active (or inactive) cableboxes on a "W" type transaction report? The account shold only list once on this report.
Something like:
Accntnum active_boxes Date trans_amt Trans_type
12345 4 06/22/03 -250.45 W
55431 2 06/22/03 -50.00 W
1. Can it be created in WEBI? How?
2. What's the easiest way in Full Client?
Thanks a bunch!