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
Hi There,
There are 2 problems about the Report Parameters.
1,I have a textbox in the pageHeaderSection and i want to set its value at runtime.Now i have add a parameter named 'Title',but i can't find any event of the report like 'loaded',there is only disposed event .So how i pass the parameter value to the textbox at runtime?
2.As we know,the SqlDataSource component supports parameterized SQL query and i'm using Oracle provider.Now i write a sql as
'SELECT * FROM Person WHERE Name in :Name' .The parameter 'Name' is a array,and my code is like ' new Parameter() {Key = "Name",Value = "('A','B','C')"}',But it doesnt work.How should I edit the 'Value' set to the parameter 'Name'?
Thanks