Pivot table does not render with datetime formatting

[Anand Kulkarni]

Hi,

I'm using the SfPivotView component and the table does not render when using a datetime row but the value is null.

I've used the following formatting.

<PivotViewFormatSetting Name="@fieldItem.Name" Type="FormatType.DateTime" Format="dd/MM/yyyy HH:mm" UseGrouping="true" ></PivotViewFormatSetting>

Note: To  reproduce send multiple datetimes with some null values.

[Yashvanth Ganesan]

Hi Anand,

Thank you for contacting Syncfusion support!

We’ve reviewed your query, and based on the information provided, we were unable to reproduce the issue on our end. The table renders properly as expected. Please refer to the output screenshot below.

Output Screenshot:

However, while working on the sample, we did observe that the filter dialog does not open when the field contains date values with null. We have confirmed this as a bug “Filter dialog fails to open for DateTime fields containing null values” and the fix will be included in our upcoming August second weekly release. You can track the status of the issue using the feedback link provided below.

Feedback link – Filter dialog fails to open for DateTime fields containing null values in Blazor | Feedback Portal

Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works re prioritization”.                                                         

Additionally, we’ve prepared and attached a sample based on the functionality described in your description to help clarify the implementation.

Note: If you would like to show or hide the null row headers in the pivot table, use the “ShowHeaderWhenEmpty” property by setting it to true or false. When set to false, null headers will be hidden from the table. Please see the screenshot below,

Code snippet:

<SfPivotView TValue="ProductDetails" ShowFieldList=true ShowGroupingBar=true Height="400" Width="1000"

         EnableValueSorting=true >

            <PivotViewDataSourceSettings DataSource="@data"      

             ShowHeaderWhenEmpty="false">

    </PivotViewDataSourceSettings>

</SfPivotView>

  

Output Screenshot:

If the problem persists, please try to replicate it using the provided sample or share a runnable sample with dummy dataSource that reproduces the issue. This will allow us to investigate the problem on our end and provide a solution as soon as possible.

Regards,
Yashvanth G G

Attachment: Blazor_null_47527b81.zip

[Yashvanth Ganesan]

Hi Anand,

We apologize for the delay. The issue has been resolved; however, due to technical difficulties, we were unable to include the fix for the reported problem in this week's release. The fix will be included in our upcoming weekly release, scheduled to be rolled out on August 19, 2025.

We appreciate your patience until then.

Regards,
Yashvanth G G

[Yashvanth Ganesan]

Hi Anand,

Thank you for your patience. We’re glad to announce that our weekly release, v30.2.6, has been rolled out. This release includes the fix for the reported issue. Additionally, we’ve prepared and attached a sample using the latest version for your reference.

Output Screenshot:

Issue Root Cause:

We resolved an issue where the filter dialog failed to open for date fields containing null values. This was due to a missing check for null or undefined conditions at the point where the dialog is triggered. The appropriate condition has now been added, ensuring the filter dialog opens reliably without errors.

We sincerely appreciate your support and patience while waiting for this release. If you need any further assistance, please don’t hesitate to reach out to us.

Regards,
Yashvanth G G

Attachment: Blazor_filter_24b2ee46.zip