Creating an Aggregation from a dependent dataset

Hi there,

I am currently running BIRT 2.3.1, and I've a problem that still couldn't resolve

For clarity, I will describe my problem in point form.

1. I have six fields, where the fields are from different datasets.
2. These datasets are dependent on the first dataset called Q1.
3. I need to get the aggregation / grand total for each of the six fields, e.g Initial Reserves, Current Reserves and etc..
4. These totals are to be showed at the footer at the end of the list.
5. I've tried creating a sub-table in a cell and binding it to the desired dataset (with the parameters included). Next, I added the aggregator using the dataSetRow expression, since I want a grand total.
6. The report displays most of the data correctly, but the total is not showing in the footer.

I'm not sure what went wrong.

Please advise on this. Thanks.

Find more posts tagged with

Comments

mwilliams

Hi mmah,

You should be able to just use an aggregation in the footer of each separate column's individually bound table. Can you recreate your issue with the sample database so I can run the report and see what you're getting?

mmah

Dear Michael,

For this case, I managed to resolve this problem. Someone told me of creating a custom parameter and then adding a small script in the onRender function.

But I'm not very sure whether this solution can be done in aggregation on group. I was told that the custom parameter, if used for group aggregation will have to be reset each time we move to a new group.

Kindly advise

Melvin

mwilliams

Melvin,

I'm not sure I'm understanding completely. If it's a static parameter value, it shouldn't need to be reset. If you're incrementing a variable to display the total, you'd have to reset that value before going to the next group.