Create view using the  Query at backend  and then use that view in the report.

 

"WK_ACT"."EQ",    (Equipment)

"WK_ACT"."WK"     (Week)

"WK_ACT"."ACT      (Activity)

 

 

SELECT
"WK_ACT"."EQ",    (Equipment)
MAX(case "WK_ACT"."WK" when 1 then "WK_ACT"."ACT"  end) 'WK1',
MAX(case "WK_ACT"."WK" WHEN 2 then "WK_ACT"."ACT"  end) 'WK2',
MAX(case "WK_ACT"."WK" WHEN 3 then "WK_ACT"."ACT"  end) 'WK3',
MAX(case "WK_ACT"."WK" WHEN 4 then "WK_ACT"."ACT"  end) 'WK4',
MAX(case "WK_ACT"."WK" WHEN 5 then "WK_ACT"."ACT"  end) 'WK5',
MAX(case "WK_ACT"."WK" WHEN 6 then "WK_ACT"."ACT"  end) 'WK6',
MAX(case "WK_ACT"."WK" WHEN 7 then "WK_ACT"."ACT"  end) 'WK7'
FROM "Test"."dbo"."WK_ACT" "WK_ACT"
GROUP BY "WK_ACT"."EQ"

 

I have done it for 7 weeks... you need to code remaining weeks.......

Output

 

EQ	WK1	WK2	WK3	WK4	WK5	WK6	WK7
A	P1					P9
C				P6
D				P3			P6

 

 

Cheers

Rahul