Create report using JsonDataSource

[Marco]

Hi, I'm working using Telerik standalone (trial) to create a report, using JsonDataSource.

In my model i have "complex" data, like object arrays. Creating the report the first issue is that all these objects are shown ad System.Object, and i need to use some data for tables (and using bindings solved problem for tables).

The problem is that i need to show charts, and i can't find a way to make it work.

[Neli]

Hello Marco,

There are two options that I can suggest demonstrated in the attached reports:

Report1:

1) Use the same approach with the Binding. I used the following JSON:

{
  'name':'John',
  'age':30,
  'cars': [
    { 'model':'Ford', 'price': 50 },
    { 'model':'BMW', 'price':42 },
    { 'model':'Fiat', 'price':8 }
  ]
 }

The graph will display the models and their prices. 

1. Аdd a pie chart with:

Series: name

Value: age

2. Remove the DataSource and set the following Binding to the graph:

Property path: DataSource

Expression: =Fields.cars

3. Change "name" with "model" and "age" with "price" in Series and SeriesGroup properties.

 

Report2:

1. Add a separate JSON DataSource with the same JSON but set the DataSelector property:

$['cars']

2. Then add the graph as usual:

Series: model

Value: price

 

Regards,
Neli
Progress Telerik

[peter]

i got a nested json and tried the above though it doesnt work, what if the array isnt key value pairs but contains json objects.
ea an array of json objects 

[Dimitar]

Could you please provide an example of your JSON structure?

Generally, the approaches suggested by Neli are the only available approaches for working with nested JSON.

Besides that, there is the option of using the Item(index,collection) function which returns the element of the collection with the given index (zero-based) but this function is generally meant to be used to get a specific item in the collection rather than listing them all as it expects an index parameter.

[peter]

i had my data as object with many child objects, now its an array of objects.
both are essentially valid though the later might be more commonly used, and it worked well. you can close this case