How to Show Data in Horizontal Table with Nested object response

2 posts, 0 answers
  1. Bharat
    Bharat avatar
    10 posts
    Member since:
    Feb 2019

    Posted 11 Apr Link to this post

    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)

  2. Todor
    Admin
    Todor avatar
    333 posts

    Posted 15 Apr Link to this post

    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
Back to Top