Can anyone tell me how to use 'SingleValueQueryFunction' in the pentaho report designer tool verion 2.0 stable?
I have a static report with columns colA, colB(pymt type), colC(amt) with a group G1.
In G1's footer, i want to a summary information to display the sum of
'colC' based on the different distinct values of 'colB'. I found that the 'SingleValueQueryFunction' will work for this scenario.
But didn't know how to implement that!!!!
Please help me on this.