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

Detail section possibility grouping

3 Answers 107 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Alexander
Top achievements
Rank 1
Veteran
Alexander asked on 24 Sep 2020, 01:57 PM

Hello everyone,

I have a question about the possibilities in the detail section:

we have multiple transports where each transport can have multiple kinds of goods and we would like to use the detail section to show both of them.

It should look like this (simplified) e.g.:


Truck A
                2 Pal. Lights
                1 Pal. Bananas
                20 Pal. Apples

Truck B
                4 Pal. Cups
                2 Pal. Gloves


…..

The problem is that in SQL we have no other possibility to join the tables so that the result looks like see att..

This will transform in multiple lines:

Truck A
                2 Pal. Lights
Truck A
                1 Pal. Bananas
Truck A
                20 Pal. Apples

Truck B
                4 Pal. Cups
Truck B
                2 Pal. Gloves

I also tried to use a table or a list Item but both would show all results for each entry.

Truck A
                2 Pal. Lights
                1 Pal. Bananas
                20 Pal. Apples
                4 Pal. Cups
                2 Pal. Gloves

Truck B
                2 Pal. Lights
                1 Pal. Bananas
                20 Pal. Apples
                4 Pal. Cups
                2 Pal. Gloves

Is there any possibility with another item, format, filter,group ..anything to get one row for each truck and with the goods for this one?

 

 


3 Answers, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 29 Sep 2020, 09:58 AM

Hi Alexander,

You may test to set table grouping. I prepared a sample report which you can find attached. The video demonstrates the required steps. You can remove the Borders of the table if you don't need them.

Let us know if you need further help.

Regards,
Neli
Progress Telerik

Five days of Blazor, Angular, React, and Xamarin experts live-coding on twitch.tv/CodeItLive, special prizes, and more, for FREE?! Register now for DevReach 2.0(20).

0
Alexander
Top achievements
Rank 1
Veteran
answered on 02 Oct 2020, 05:54 AM

Helo Neli,

that is a cool feature to know - sadly Ihave also other details in the detailsection.

so the table is a part in the detail section. If i group the table then i get the detail section like this:

    Tour Number 1 (Truck A)

    Loadingplace: ... Reference: ....

    ...

    (Grouped Table:)

        Truck A:

        Truck B:

    Tour Number 2 (Truck B)

    Loadingplace: ... Reference: ....
    ...
    (Grouped Table:)

        Truck A:
        Truck B:

So basically at each entry i get all table results grouped. Is it possible to pass parameters to a table within the detail section?

Can you group the whole detailsection?

Regards Alex

0
Neli
Telerik team
answered on 07 Oct 2020, 08:46 AM

Hello Alex,

You can consider the usage of report groups. I modified the previously attached report as follows:

- Remove the group of the table;

- Bind the CSV DataSource to the report;

- Add two groupings- one for the Tour Number and another for the Truck;

- Remove the DataSource of the table and set it through Binding:

Property path: DataSource

Expression: = ReportItem.DataObject

- Set the Visible property of the group footer sections to False.

Please, check the updated report and let us know if you need further help.

Regards,
Neli
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Report Designer (standalone)
Asked by
Alexander
Top achievements
Rank 1
Veteran
Answers by
Neli
Telerik team
Alexander
Top achievements
Rank 1
Veteran
Share this question
or