Hello Everyone,
I have been given a task to develop a SSRS report that Mimic's a ASP.net grid. this grid has four column headers such has
- Measures
- Jan 2006
- Feb 2006
- Mar 2006
First "Measure" Column as all the measure captions as the data in rows and other 3 columns (Jan 2006,Feb 2006,Mar 2006 Dimensions) has the measure values as the data in the row.
Measure Jan 2006 Feb 2006 Mar 2006
Profit 12.32 15.23 15.0
Revenue 12.33 16.33 11.22
ROI 2 4 5
In SSRS MDX is not flexible as writing in Query Analyzer , can some one give me the idea how to create this in SSRS report designer.
Thanks,
Pradeep. | |