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!>
Thanks for joining our community and helping improve Syncfusion products!
| 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>