ReportServer Forum

Johann

Member

Registered: 2022-05-30

Grid Editor reports: Error displaying Date/Datetime columns

I have a table with datetime values such as: 2015-01-01 00:00:00

Using the following snippet adapted from the documentation:

def adapter = gridHelper.initDbGridEditor()
adapter.configure(report, '<<TABLE_NAME>>')
        .columns()
            .add('<<DATE_TIME_COLUMN')
        .done()

return adapter;

I get the following error:

The report could not be executed: java.time.LocalDateTime cannot be cast to java.util.Date

What am I missing here?