- Solutionskeyboard_arrow_down
- Productskeyboard_arrow_down
- Resourceskeyboard_arrow_down
Our Black Friday offer is live! Apply code BLACKFRIDAY2025 at checkout and save $100. See Pricing
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 | Hanari Carnes | Folk och fä HB | Ernst Handel | Que Delícia | Rattlesnake Canyon Grocery | Victuailles en stock | Lonesome Pine Restaurant | Vins et alcools Chevalier | Richter Supermarkt | Wartian Herkku |
| Amount | ¤3,257.80 | ¤2,987.00 | ¤4,483.40 | ¤1,000.80 | ¤9,130.40 | ¤815.60 | ¤712.00 | ¤1,100.20 | ¤2,490.50 | ¤3,210.80 |
Save Hours on Every Project
With Radzen Blazor subscription you get the full toolkit, including:
Dedicated support backed by proven expertise
Premium themes and theme editor
Ready-to-use UI blocks
Complete app templates
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