Multiple columns and total based on the visible columns

Hi,

I am attaching my report design.

It works perfect with two input parameters(columns) and am sure it will work with multiple paramters/columns.

The only thing is the aggregation equation in the Total column will be tedious.

Is there a simpler way to do this rather than hard coding it.

Thank you.

Find more posts tagged with

Comments

mwilliams

You could always try adding the values of each column depending on the column visibility in each element's onCreate script and just reset the value of the variable to 0 at the beginning of each row. Just an idea. I haven't tried this yet, so you might try it. Let me know if you have questions or need a better explanation.