Group by without SQL-Statement

[mocoeg]

Hello Guys

I have the following situation:

TABLE_1 with the columns: OBJECTID, FUNCTION, LENGTH

Now i need to sum-up the LENGTH grouped by the FUNCTION. I can do this with a SQL statement like that:

select sum(LENGTH), FUNCTION from TABLE_1 group by FUNCTION.

But is there a possibility to do this with the tools from Stimulsoft and without a SQL statement?

Thanks for your help!
mocoeg

[HighAley]

Hello.

I have the following situation:

TABLE_1 with the columns: OBJECTID, FUNCTION, LENGTH

Now i need to sum-up the LENGTH grouped by the FUNCTION. I can do this with a SQL statement like that:

select sum(LENGTH), FUNCTION from TABLE_1 group by FUNCTION.

But is there a possibility to do this with the tools from Stimulsoft and without a SQL statement?

You could create data Source from other DataSource.

Look at the attached report template .

Thank you.