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!
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!