www.radzen.com
- Solutionskeyboard_arrow_down
- Productskeyboard_arrow_down
- Resourceskeyboard_arrow_down
Radzen Blazor Components
DataGrid crosstab data support
Sometimes your data comes from crosstab queries and you need to present rows as columns.
In this demo a crosstab query groups Orders by Year and Company, calculates total amounts, then transposes years into columns to show two rows: one displaying company names and one showing amounts in currency format.
Year | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 |
|---|---|---|---|---|---|---|---|---|---|---|
| Company | Suprêmes délices | Berglunds snabbköp | QUICK-Stop | Victuailles en stock | Hanari Carnes | Chop-suey Chinese | Toms Spezialitäten | Richter Supermarkt | Split Rail Beer & Ale | Vins et alcools Chevalier |
| Amount | ¤6,438.80 | ¤2,102.00 | ¤7,520.00 | ¤815.60 | ¤3,257.80 | ¤625.20 | ¤1,863.40 | ¤2,490.50 | ¤4,867.40 | ¤1,100.20 |
All the tools in one place
Save Hours on Every Project
With Radzen Blazor subscription you get the full toolkit, including:
support
Dedicated support backed by proven expertise
palette
Premium themes and theme editor
widgets
Ready-to-use UI blocks
dashboard_customize
Complete app templates
format_shapes
Visual design-time-experience
Radzen Blazor Components, © 2018-2025 Radzen.
Source Code licensed under
MIT
- UI Fundamentalskeyboard_arrow_down
- UI Blocks Prokeyboard_arrow_down
- App Templateskeyboard_arrow_down
- DataGrid Updated keyboard_arrow_down
- Data-bindingkeyboard_arrow_down
- Virtualizationkeyboard_arrow_down
- Columns Updated keyboard_arrow_down
- Filtering Updated keyboard_arrow_down
- Hierarchy Updated keyboard_arrow_down
- Selection Updated keyboard_arrow_down
- Sortingkeyboard_arrow_down
- Paging Updated keyboard_arrow_down
- Grouping Updated keyboard_arrow_down
- Custom Headerkeyboard_arrow_down
- Save/Load settings Updated keyboard_arrow_down
- Drag & Drop Updated keyboard_arrow_down
- PivotDataGrid New keyboard_arrow_down
- Data Updated keyboard_arrow_down
- DataListkeyboard_arrow_down
- DataFilterkeyboard_arrow_down
- Treekeyboard_arrow_down
- Imageskeyboard_arrow_down
- Layout Updated keyboard_arrow_down
- Navigationkeyboard_arrow_down
- Formskeyboard_arrow_down
- DropDownkeyboard_arrow_down
- HtmlEditorkeyboard_arrow_down
- Data Visualizationkeyboard_arrow_down
- Chartkeyboard_arrow_down
- Feedbackkeyboard_arrow_down
- Alertkeyboard_arrow_down
- Validatorskeyboard_arrow_down
Demos Configuration
Premium Themes
- Material 3
- Material 3 Dark
- Fluent
- Fluent Dark
Free Themes
- Material
- Material Dark
- Standard
- Standard Dark
- Default
- Dark
- Humanistic
- Humanistic Dark
- Software
- Software Dark