bitsmith2k
Programmer
Hey All, I havent spent too much time trying this on my own yet, but i'm assuming i will run into trouble perhaps someone here would be able to help me out..
here's how my data relates:
contract
contractID
portfolioid
transactions
transid
contractid
transtype
transactiontypes
transtype
paymenttype
Here's my task..
we have a bunch of transactions that i need to report.. some transtypes for the transactions are marked as paymenttype = 1. these are the guys i want to report.
i want to use a crosstab to display the data ie:
contractid sum(transtype1) sum(transtype2).....sum(transtypeN)
no problem getting that info displayed.. is there a way to group data within the crosstab based on the portfolioid of the contract record while preserving all the columns?
i ask because if we add another transtype that is a paymenttype i want it reflected in the report without making any code changes?
any ideas how this can be done?
here's how my data relates:
contract
contractID
portfolioid
transactions
transid
contractid
transtype
transactiontypes
transtype
paymenttype
Here's my task..
we have a bunch of transactions that i need to report.. some transtypes for the transactions are marked as paymenttype = 1. these are the guys i want to report.
i want to use a crosstab to display the data ie:
contractid sum(transtype1) sum(transtype2).....sum(transtypeN)
no problem getting that info displayed.. is there a way to group data within the crosstab based on the portfolioid of the contract record while preserving all the columns?
i ask because if we add another transtype that is a paymenttype i want it reflected in the report without making any code changes?
any ideas how this can be done?