Aggragation performed only on visible columns

Hi,

Attached is the report for your reference.
And the report can be viewed at
http://wisdom.rockefeller.edu:8080/birt/frameset?__report=testmult.rptdesign

Here I have visibility property set for the first three columns that are drop down lists in the parameters.
However, I have a fourth column "Unique" (aggregation but done slightly in a different way, you can see the logic in the report design).
The Unique column logic must be based only on the columns that are visible.
My logic used in aggregations is :
if (if (row["NAME1"] == 0 & row["NAME2"] == 0 & row["NAME3"] == 0)
{0}
else
{1}

So if NAME1 and NAME2 is hidden, then row["NAME1"] and row["NAME2"] must not be considered in the above aggregation equation.

Any siggeastions please.

Thank you,
Aparna J

Find more posts tagged with

Comments

ajunuthula

Hi,

Attached is the report for your reference.
And the report can be viewed at
http://wisdom.rockefeller.edu:8080/birt/frameset?__report=testmult.rptdesign

Here I have visibility property set for the first three columns that are drop down lists in the parameters.

However, I have a fourth column "Unique" (aggregation but done slightly in a different way, you can see the logic in the report design).

The Unique column logic must be based only on the columns that are visible.
My logic used in aggregations is :

if (if (row["NAME1"] == 0 & row["NAME2"] == 0 & row["NAME3"] == 0)
{0}
else
{1}

So if NAME1 and NAME2 is hidden, then row["NAME1"] and row["NAME2"] must not be considered in the above aggregation equation.

Any siggeastions please.

Thank you,
Aparna J

mwilliams

Since you use your parameter values to determine which columns to show/hide, you can also use these parameter values to determine which columns to use in the aggregation.

ajunuthula

So you mean I should check the parameter value and then use the aggregation equation accordingly.

Something like,

if (params["Author1"].value==null & params["Author2"].value==null & params["Author3"].value==null)
{
if (if (row["NAME1"] == 0 & row["NAME2"] == 0 & row["NAME3"] == 0)
{0}
else
{1}
}
else if (params["Author1"].value != null & params["Author2"].value==null & params["Author3"].value==null)
{if (if (row["NAME2"] == 0 & row["NAME3"] == 0)
{0}
else
{1}
}
else if

and so on

What if I have more than 3 parameters, assume around 10?

Correct me if am wrong.

Thank you.

mwilliams

That would be one way. You could probably step through your parameters using reportContext.getDesignHandle().getAllParameters() and automate the process a little.

ajunuthula

Hi,

As per your suggestion, am trying to use the designhandle to get all parameters.

But am stuck, got the code online, but can you please suggest me how to check the condition as:

if params["Author1"].value != null then
if (datasetrow["NAME1"] == 1) then 1 else 0
and so on for the remaining 3 parameters.

Any suggestions please.
The report design is attached in earlier post.

Thank you,
Aparna J

mwilliams

Take a look at this report. You'll see in the binding expression for the "Unique" field that I build a javascript string to be evaluated, based on the parameter values. If all columns are hidden, 0 is returned for all rows of "Unique". This is one way to automate the process, so you don't have to have a check, for every scenario. You just build the if dynamically. Hope this helps.