Printing on the same line

[Michael Million]

Assume my data looks like this:
cat 1       cat 2        value
1            1                2
1            1                3
1            2                1
1            2                2
1            2                3
1            2                4
2            1                1


I'd like my report to look something like:
cat 1: 1
    cat 2: 1
        2,3

    cat 2: 2
        1,2,3,4

cat 1: 2
    cat 2: 1
        1

The issue I'm having is trying to get the last line to work in a windows application. From what I can understand, these records would have to be on separate lines.  I'd like to append all of them for a cat1, cat2 grouping.

Can I do this with the reporting engine or will I have to do some trickery behind the scenes in my business logic?

I hope I've explained this adequately enough for you to understand my question.

Thanks!

[Steve]

Hello Michael,

What you're trying to accomplish can be achieved with the help of rotated table item i.e. table that develops itself in columns instead of rows. Also note that the Table is bound by using the Bindings property to the underlying data source for the current group with the following expression: =ReportItem.DataObject. This approach is also used in our ProductCatalog demo report.

I've attached a sample report that uses your data (see screenshot) for your convenience.

Greetings,
Steve
the Telerik team