How to Use JSON Parameter to Dynamically Set TextBox Values in a Report?

[Arifullah]

Hi,

I am trying to pass a parameter of JSON type to my Telerik Report, like this:

json
Copy code
{
    "orderNo": "Order No",
    "customer": "Customer",
    "date": "Date"
}

or in Arabic:

json
Copy code
{
    "orderNo": "رقم الطلب",
    "customer": "العميل",
    "date": "التاريخ"
}

I want to use these values dynamically in my report's TextBox. For example, to display the value of "date", I tried the following approaches, but neither worked:

1. =Parameters.Columns.Value("date")

I am doing this because I want to dynamically pass translated field labels to the report. Could you please guide me on the correct way to achieve this?

Thank you!

[Todor]

Hi Arifullah,

Indeed, the Report Parameters may have values with particular types. When you pass JSON as a value to a Report Parameter it is treated as String and its properties cannot be determined automatically.

As a workaround, you may use a List with JsonDataSource, which Source is bound to the parameter as explained in the KB article How to set the content of JsonDataSource through report parameter.

Regards,
Todor
Progress Telerik