Report Layout

[Nick]

Im having trouble getting a report to layout as I'd like. The report needs to have multiple rows for each record that is returned from the database. No matter what I try, I cant get the report to layout correctly. As soon as I have multiple rows per record, the rows always move to the bottom of the section and only return once. An example of what I need to look like is attached. What its returning like is also attached. Any ideas on what I can do?

Thanks,

Nick

 

Needs To Be

Currently Is - Missing most of the data

[Nick]

I never heard back about this. Is it not possible?

[Stef]

Hi Nick,

The layout can be done with Telerik Reporting.
You need to prepare data in a structure where you have the flatten representation of the hierarchy e.g.:

Org,Part,Description
Org1,Part1,test1
Org1,Part1,test2
Org1,Part2,test12
Org1,Part2,test123
Org1,Part2,test1234
Org2,Part1,sample

Note how grouping data is repeating. The repeating fields can be used in groupings - Grouping data.

For example:

1. Start a Band Report Wizard and specify a grouping by Fields.Org. Finish the wizard without adding any other data;
2. In the GroupHeaderSection start a Table Wizard - make the Table item display Fields.Description only;
3. Open the Group Explorer and add a parent row group by Fields.Part in the Table item's row groups;
4. Open the Table item's bindings collection and change its DataSource to be =ReportItem.DataObject (the data associated with the parent element) - Use DataObject as a datasource for nested data items (Table, List, Crosstab, Graph);
5. Style not needed elements and sections to be hidden.

The approach is illustrated with the attached video, that is a SWF file that can be previewed in IE browser with installed Flash. The report from the video is a TRDP file that can be previewed with the Standalone Report Designer of Telerik Reporting R2 2017 and newer.


Please note that we cannot guarantee responses by Telerik representatives in forums in a timely manner. Our recommendation is to use the support ticketing system if you need the issue to be addressed by the team handling the product.

Thank you for your understanding.

Regards,
Stef
Progress Telerik