This is a migrated thread and some comments may be shown as answers.

How to Show Data in Horizontal Table with Nested object response

1 Answer 175 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Bharat
Top achievements
Rank 1
Bharat asked on 11 Apr 2019, 05:27 AM

Hello Telerik Team

This is my Response 
{
    "Response": null,
    "Response": null,
    "Response": {
        "Response": {
            "Response": [
                {
                    "Response": [
                        {
                            "Response": [
                                {
                                    "Response": [
                                        {
                                            "Response": 35,
                                            "Response": 2,
                                            "Response": 2,
                                            "Response": 31,
                                        }
                                    ],
                                    "Response": 5,
                                    "Response": null,
                                    "Response": "789",
                                },
                            ],
                            "Response": 0,
                            "Response": null,
                            "Response": "45",
                        },
                    ],
                    "Response": 9,
                    "Response": null,
                    "Response": "712",
                },
            ],
            "Response": "xyz",
            "Response": "XYZ",
            "Response": "XYZ",
            "Response": "12",
            "Response": "123",
        }
    }
}

Now i want  to show this response in this design (My Design: Report should Look Like this)

I tried to design report using table but it looks like this (Actual Report: Report Created Using Table)

Also Tried with Crosstab but it was not looking good

i show your Demo Product Catalog ( https://demos.telerik.com/reporting/product-catalog?&skinName=default ) but it is just showing result it is not showing how can i do this.
I want to show my data same as you show in your demo.

also help me to show Icon as my design have (image: Report should Look Like this)

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 15 Apr 2019, 02:31 PM
Hello Bharat,

The provided JSON contains several data levels. I assume that not all the fields are named "Response", as some are collections and some are simple types (i.e. String or Integer). Generally, the hierarchy of the JSON may be structured in a List item with nested Lists for the collections and TextBoxes for the simple type data. The exact scenario is not very clear to me from the screenshots. Does the data on each level include a single array followed by several Integers/Strings? Are the nesting levels constant number (e.g. 7)?

You may see the design of the report ProductCatalog in our examples that come with the installation of Telerik Reporting. The can be found by default in :
 - CSharp (VB) reports - (Telerik Reporting installation folder)\Examples\CSharp(or VB) (e.g. C:\Program Files (x86)\Progress\Telerik Reporting R3 2018\Examples\CSharp). The project name is CSharp.ReportLibrary.
 - TRDP (Standalone designer) reports - (Telerik Reporting installation folder)\Report Designer\Examples (C:\Program Files (x86)\Progress\Telerik Reporting R1 2019\Report Designer\Examples)

For icons you may use Shape or PictureBox with the corresponding image.

You may open a support ticket and send a runnable report including sample data that demonstrates the exact data structure. We would inspect it and try to provide more particular advises.

Regards,
Todor
Progress Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Report Designer (standalone)
Asked by
Bharat
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or