I'm interested in recreating some of the ReportViewer functionality - possibly something via regular GridView or something similar.
My two main requirements:
- Pivot functionality - as seen on the ReportViewer matrix
- Standards based design - maybe adding ids/classes on the backend based on the results
Also - I will be pulling data form a db via a dataset so all I really would need to do is format the raw dataset into an intuitive pivot.
What's the best practice? Should this be even done in ASP.NET/C# or would SSRS/SQL be a better alternative?