Override Report Data Preload

[Craig]

Hi,

I am trying to override some report data values using the ItemDataBinding or Bound events, specifically I am looking for DateTime type values so I can override them with a local time conversion. Our DB stores all times in UTC and these need to be shown in local time on our website using the Report Viewer.

It is my understanding Reports has no native capability to do this (please let me know if I'm wrong!). I have been able to detect the values I need to override in the ReportBaseItem.DataObject object / RawData object instance using the properties collection (descriptor) method GetValue however SetValue seems to have no impact on the RawData and fails to reflect my update.

I would appreciate if anyone could provide any hints that may point me in the right direction.

Regards,
Craig

[Steve]

Hello Craig,

Time conversion is not among the supported features of a reporting product, so yeah, you would have to do this manually. The best approach would be to handle the data used as datasource and convert it prior displaying in the report. Interfering with the report life cycle and replacing values at runtime is not a good idea as changing the value could also cause unexpected changes in the layout as the new content would not be measured.

Greetings,
Steve
the Telerik team