Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Adding column to a dataset programtically
Migrateduser
Hi everyone,
I'm having some trouble developing report for following situation.
I have a database containing transaction details. It contains both credit and debit transactions. Fields I've are userId, dateTime, trxId, amount, trxType
In the transaction report for a user I've to show all the transactions(both credit & debit), but have to show them in two different columns. Report should look like follows.
TrxId | Credit | Debit
1 | 100 |
2 | | 500
Total |100 | 500
I was thinking of updating the dataset programatically and add two new columns credit and debit. But I don't know how to do that. I tried to use DataSourceEventAdapter.onFetch, but it do not support add new column to the data set.
I'm using JDBC data source here.
Can anyone help me on this...
Thanks in advance,
Regards,
Sandarenu.
Find more posts tagged with
Comments
There are no comments yet