Facebook
Example 1:
Step 1: Drag matrix
Step 2: Select column to be displayed horizontally in column group.
Step 3: Delete row group 
Step 4: Delete Column header but delete only row not associated group.
 
Example 2:
Step 1: Generate a view with row number and column which you want to use horizontally.
CREATE view CustWithRow
as
SELECT      row_number() over(order by customerid) rownum,  CompanyName 
FROM            Customers
Step 2: Generate output using PIVOT operator.
CREATE VIEW DynamicCol
as
 SELECT 
[1] [Col1],[2] [Col2],[0] [Col3]
FROM
(SELECT CompanyName, rownum%3 rownum,row_number() over(partition by  rownum%3 order by CompanyName) rn
    FROM CustWithRow) AS SourceTable
PIVOT
(
max( CompanyName)
FOR rownum IN ([0],[1],[2])
) AS PivotTable;
Step 3: Use view directly on report.

Leave a Reply

Your email address will not be published. Required fields are marked *