nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Computed Columns

Dakmen

Hi
Please help me
In my dataset are computed columns
Is possible change Property before open dataset ? For example change aggregateFunction and arguments for computed column "COMP" in dataset "produkcion"

I tried something like:

dataSetHandle = reportContext.getReportRunnable().designHandle.getDesignHandle().findDataSet("produkcion");
computedSet = dataSetHandle.getPropertyHandle(dataSetHandle.COMPUTED_COLUMNS_PROP);
computedCol = computedSet.getItem( "COMP"); ???????
...
computedCol.setExpression("10");
computedCol.setDataType("decimal");
computedCol.aggregation ...????
...

How is it correctly ?

Thanks

Find more posts tagged with

Comments

mwilliams

What exactly are you trying to do in which you'll change the aggregation function? Based on a user input parameter?

Dakmen

Yes. Based on user input (static) or parametr read from database (dynamic binded with dataset)

Dakmen

Hello
Any reason for problem user change aggregation function in computed column based on user input ?
Thank you very much

Rajesh kmr

do you want to give a user option to select which aggregate function he want to perform on a certain group??

if this is your requirement then we can write if else condition in on aggregate functions..

on data field.

if this is your requirement then i can send you code for that..

Dakmen

Haloo Thank you very much for your answer
I try to explain my need
In my datasource is computed column for example "statistical"
when you define aggregation function for this column, you can choose only form combobox. (Expression builder is here invisible.
I need this aggregation function (count, median, percentil etc.) in computed column "statistical) later
Also I need determine groupation function for computed column in dataset based on input from user (parameters)
This statistical value is intended for restriction in graph. Is topN or IstopN percent etc.

mwilliams

So, you want to have a report that shows a chart. You want the user to have control on whether this chart includes the Top N or the Top N Percent of values? Is this correct?

Dakmen

Sorry for my delayed answer.Yes I want the user to have control on type of grupation in chart. TopN or TopN or or...