Combine Table Multiple Rows Into One Report Row

rbuser

I would like to combine multiple rows from a database table into one row on
the report. I would want all of the data from the 1st record of the group.
I would pick 1 or 2 fields from the subsequent records to add on to the
single report row. Is this possible to do within Report Builder? I have
one field that I would key on that would signal that it is time to go to a
different row.

Thanks,

Al Willis

digitalmetaphors

One approach would be too first provide these records in the dataset that
you want to print. Do you have criteria in the WHERE clause that filters the
other records down to 1-2 additional records that you want to print on the
same row? Try setting the columns property of the report to the number of
database records that you want to print on one row. Then set the
DetailBand.ColumnTraversal to LeftToRight. You could create a group on a
custom field to get the row to break, based on a text value you provide.
Whenever the value changes, the groups will break. Use the
Group.OnGetBreakValue event to set the break value from the datapipeline for
the 'signal key' field link you have in your dataset.


Cheers,

Jim Bennett
Digital Metaphors