Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Column Grouping report - rows with diff col count

Author  Topic 

bushfoot
Yak Posting Veteran

53 Posts

Posted - 2010-10-06 : 16:23:30
I have a column grouping report where each row MIGHT have the same number of columns.

For example,
Emp x has call types: internal, ld, toll free
Emp y has call types: ld, toll free
Emp z has call types: internal, ld, toll free

Coming out of sql the data is sorted by emp, then call type
Emp x internal
emp x ld
emp x toll free
emp y ld
emp y tollfree
emp z internal
emp z ld
emp z tollfree

Emp y is at the bottom of the report.

Is this standard behavior for Column grouping reports? Is it expected that each ROW of the report will have the SAME NUMBER OF COLUMNS (even tho the number of columns is unknown)?

I do NOT have any sorting set in the rdl doc.
   

- Advertisement -