I have a sql table with Monthly remarks. Each month has 2 or more than two remarks entries SQL Table name #MonthWiseRemarks
| ID | Year | MonthName | Remarks |
|---|---|---|---|
| 1 | 2022 | December | DecemberRemarksEntry |
| 2 | 2023 | January | JanuaryRemarksEntry1 |
| 3 | 2023 | January | JanuaryRemarksEntry2 |
| 4 | 2023 | January | JanuaryRemarksEntry3 |
| 5 | 2023 | February | FebruaryRemarksEntry1 |
| 6 | 2023 | February | FebruaryRemarksEntry2 |
Can you please help me this table data convert to like this Using with RDLC report & grouping
Result should be like this
| 2022 - December | 2023-January | 2023-February |
|---|---|---|
| DecemberRemarksEntry | JanuaryRemarksEntry1 | FebruaryRemarksEntry1 |
| - | JanuaryRemarksEntry2 | FebruaryRemarksEntry1 |
| - | JanuaryRemarksEntry3 | - |
I tried row grouping and column grouping in rdlc report.but I didn't get exact output.
