Order datapipeline

rbuser

Hi,

We are working with Delphi 6 Enterprise and Report Builder Pro 6.03.
We pass to the report a table of products and we want to group this
table by code field.
We use the group property of Report Builder, but it doesn't run ok if
the table is not ordered.

For example, if in the table appears:

code quantity
000 5
000 10
001 3
000 4
000 7

in the report appears:

code quantity
000 15
001 3
000 11


But We want:

code quantity
000 26
001 3

Is possible to do it? How?

Thank's

nicocizik

Hello,

The easiest way to do this would be to use SQL to process the data before
displaying it in your report. It looks as though you need to use the GROUP
BY command to group all the similar codes and then perhaps an aggregate
function to sum the quantities.

--