- 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 | Suprêmes délices | Richter Supermarkt | Ernst Handel | HILARION-Abastos | White Clover Markets | Que Delícia | Toms Spezialitäten | Hanari Carnes | Magazzini Alimentari Riuniti | Vins et alcools Chevalier |
| Amount | ¤6,438.80 | ¤2,490.50 | ¤4,483.40 | ¤1,119.90 | ¤676.00 | ¤1,000.80 | ¤1,863.40 | ¤3,257.80 | ¤915.20 | ¤1,100.20 |
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