Strange telerik reporting parameters question from a rookie.

[Mirsad]

Hi. This is probably an easy question for somebody to answer but it is driving a noobie like me nuts tonight. I have a report that has 3 parameters (date_start, date_end, worker). I set up the parameters as usual and assigned some default values to them.   I have some tables that use a sqldatasource to  display some data based on those parameters. This works fine. I have absolutley no isues with the tables displayign data using the parameters

What I am trying to do is use some code behind (presumably in itemdatabound event) to do a calculation and display some text in a textbox based on the number of days between start and end date parameters. I can get this calculated data to display. but it always displays values based on the default value of the parameters and not what is selected in the dropdowns for the parameters. if i clear the default values from the parameters, the report errors out because it thinks the default values for the dates are blank or null.
 
Does the itemdatabound event fire before the parameters are available to use and calculate against?

What should I be doing?

[Peter]

Hi Mirsad,

Most probably you have used the Report Parameter definition item instead of the processing counterpart. The definition report parameter value is actually the default value. The sender of the event is always the processing counterpart of the data item and you can use it to access the processing report parameter. For more information check out the Using Report Parameters programmatically.

However based on your description it seems that you can utilize user function instead of event.

Regards,
Peter
Telerik

[Mirsad]

Yes, I am using the code below to try and retrieve the user entered parameters but all I can retrieve are the default parameters:

Private Sub detail_ItemDataBound(sender As System.Object, e As System.EventArgs) Handles detail.ItemDataBound


        Dim Date1 As DateTime = Convert.ToDateTime(Report.ReportParameters("Start").Value).ToShortDateString
        Dim Date2 As DateTime = Convert.ToDateTime(Report.ReportParameters("End").Value).ToShortDateString
        Dim Date1x As DateTime = Convert.ToDateTime(Report.ReportParameters("Start").Value).ToShortDateString
        Dim Date2x As DateTime = Convert.ToDateTime(Report.ReportParameters("End").Value).ToShortDateString
        Dim entered_by As String = (Report.ReportParameters("Servicedby").Value)

[Peter]

Hello,

As shown in the Using Report Parameters programmatically help article you can access the processing report parameters as shown in the following code snippet:

Private Sub detail_ItemDataBound(sender As System.Object, e As System.EventArgs) Handles detail.ItemDataBound
        Dim detail = DirectCast(sender, Telerik.Reporting.Processing.Detail)
        Dim Date1 As DateTime = Convert.ToDateTime(detail.Report.Parameters("Start").Value).ToShortDateString

Regards,
Peter
Telerik