Welcome to the Blazor feedback portal. We’re happy you’re here! If you have feedback on how to improve the Blazor, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

0
Votes
I have the following data in the database as follow.

Status
Date
Amount



Invoice
01/01/2024
72.00



Invoice
01/07/2024

72.00




Credit Notes
01/01/2024
3.99



Credit Notes
01/07/2024
4.00



Credit Notes
01/01/2024
5.04



Credit Notes
01/07/2024
5.04



System showed after developing the program.

Green box of the data are not showed correctly.But the way we select from database is correct. Please kindly help and we developed the program like this:

<SfGrid DataSource="@InvoicePivotedList" TValue="InvoicePivotedData" @ref="gvInvoiceOverview" GridLines="GridLine.Both">
                        <GridColumns>
                            @if (InvoicePivotedList != null && InvoicePivotedList.Any())
                            {
                                <GridColumn Field="InvoiceHeadID" HeaderText="InvoiceHeadID" Visible TextAlign="TextAlign.Center" Width="100">
                                    <Template>
                                        @{
                                            invoicePivotedData = (context as InvoicePivotedData);
                                            <span>@invoicePivotedData.InvoiceHeadID</span>
                                        }
                                    </Template>
                                </GridColumn>
                                <GridColumn Field="InvoiceNo" HeaderText="Invoice No" TextAlign="TextAlign.Center" Width="100">
                                </GridColumn>
                                <GridColumn Field=ReleaseTinyint HeaderText="Release" TextAlign="TextAlign.Center" DisplayAsCheckBox="true" Width="80"></GridColumn>
                                <GridColumn Field=CancelledTinyint HeaderText="Cancellation" TextAlign="TextAlign.Center" DisplayAsCheckBox="true" Width="100"></GridColumn>
                                <GridColumn Field=CancelledDate HeaderText="Canc.date" Format="dd.MM.yyyy" Width="100"> </GridColumn>
                                <GridColumn Field="UnderWriterNo" HeaderText="Underwriter" Width="100"> </GridColumn>
                                <GridColumn Field="UnderWriterName" HeaderText="Underwriter name" Width="200"> </GridColumn>
                                <GridColumn Field="InterestNo" HeaderText="Interest" Width="100"> </GridColumn>
                                <GridColumn Field="InterestName" HeaderText="Interest description" Width="200"> </GridColumn>
                                <GridColumn Field=InvoiceDate HeaderText="Invoice Date" Format="dd.MM.yyyy" Width="100"></GridColumn>
                                <GridColumn Field="Currency" HeaderText="Curr." Width="80"> </GridColumn>
                                <GridColumn Field="InvoiceHeadAmount"  HeaderText="Amount" Width="100"> </GridColumn>
                                <GridColumn Field="InvoiceType"  HeaderText="Type" Width="80"> </GridColumn>
                                <GridColumn Field="User" HeaderText="User" Width="80"> </GridColumn>                                foreach (var item in InvoicePivotedList.FirstOrDefault().InvoicePivotColumns)
                                {
                                    <GridColumn HeaderText="@item.VirInstalment"  Width="100" CustomAttributes="@(new Dictionary<string, object>(){ { "class", "custom-css" }})" >
                                                 <Template>
                                                @{
                                                    var IDate = @item.InstalmentDate == DateTime.MinValue ? string.Empty : @item.InstalmentDate.ToString("dd.MM.yyyy");
                                                //@item.InstalmentDate.ToString("dd.MM.yyyy")
                                                    <span>@IDate</span>
                                                 }
                                                </Template>
                                    </GridColumn>
                                    <GridColumn HeaderText="@item.VirInvoiceHeadRate" Width="100">
                                                 <Template>
                                                    @{
                                                        <span>@item.InvoiceHeadRateAmount</span>
                                                    }
                                                </Template>
                                    </GridColumn>
                                    <GridColumn HeaderText="@item.VirPaymentDate" Width="100">
                                                 <Template>
                                                    @{
                                                        <span>@item.PaymentDate</span>
                                                    }
                                                </Template>
                                    </GridColumn>
                                }                                foreach (var item in InvoicePivotedList.FirstOrDefault().InvoicePivotColumns)
                                {
                                    <GridColumn HeaderText="@item.VirInvTax" Width="100">
                                                 <Template>
                                                    @{
                                                        <span>@item.InvTaxAmount</span>
                                                    }
                                                </Template>
                                    </GridColumn>
                                }                            }
                        </GridColumns>
                    </SfGrid>