Crosstab by using Web Service data source

[sg]

Hi,

I am using Web Service data source to generate a report with Crosstab. 

Below is my sample data from Web Service:

{
    "totalCount": 3,
    "dataSet": [
        {
            "Department": "Dept1",
            "Type": "Type1",
            "Amount": "10"
        },
        {
            "Department": "Dept1",
            "Type": "Type2",
            "Amount": "50"
        },
        {
            "Department": "Dept2",
            "Type": "Type1",
            "Amount": "15"
        }
    ]
}

It supposed to generate 2 columns and 2 rows in Crosstab, but it shows only first record and in Grand total column, it is showing 2 grand total in same column. (Please refer to my screenshot)

I also attached my datasource binding and fields in Crosstab.

Please help.

Thank you.

 

 

[sg]

Have found the rootcause of the issue. After I added both column and row group in Crosstab, the records display correctly now.

[Yana]

Hello,

A possible approach to handle the scenario is to use JSONPath to filter the received data and set directly the nested array as a data source to the CrossTab. Please find attached a sample report showing exactly what I mean.  I used JSONDataSource for the example with inline json data.

Give it a try and let me know if you have any additional questions on this.

Regards,
Yana
Progress Telerik