Hi guys, just wondering if the telerik reporting pack can support Dynamic columns via the use of Pivot query(row data to column header)
i already have my SQL code set, and i cant have both Crystal Reports and SSRS work for me..
Let me know thank you!
i already have my SQL code set, and i cant have both Crystal Reports and SSRS work for me..
Let me know thank you!
2 Answers, 1 is accepted
0
Hi Bryan,
Peter
the Telerik team
We have used Pivot operator in our DashBoard salesPersonQChartDataSource query. Thus you can utilize Pivot with our SqlDataSource components to generate a Crosstab with dynamic column groups. You can download a free trial to check out if Telerik Reporting is covering your scenario.
Best wishes,Peter
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items
0
Glenn
Top achievements
Rank 1
Rank 1
answered on 13 Oct 2012, 10:18 AM
That query warps the pivot in an outer query - that is fine when you know the columns returned in the pivot, but in most cases you don't.
Can you please provide a working example with the pivot being the outer most statement?
select * from
(
-- inner statement...
) t
PIVOT (SUM(total) FOR category IN (...) AS pvt
Can you please provide a working example with the pivot being the outer most statement?
select * from
(
-- inner statement...
) t
PIVOT (SUM(total) FOR category IN (...) AS pvt