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

dynamic repeating tables

2 Answers 108 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Peter
Top achievements
Rank 1
Peter asked on 14 Feb 2012, 11:17 AM
I have the following dataset:

organisation client pos desc total
a 1 1 a 10
a 1 2 b 11
a 1 3 c 12
a 2 1 d 20
a 2 2 e 21
a 2 3 f 22
a 3 1 g 30
a 3 2 h 31
a 3 3 i 32
b 1 1 j 40
b 1 2 k 41
b 1 3 l 42

An organisation can contain one client, but a second organisation has several clients.
The report is generated at the organisation level.

I need on this organisation report per client a table. See attached file for more information.

How do I create this table? Do i need a normal table with grouping? a cross table? or perhaps a sub-report?
I prefer to generate it completely in the designer, if possible!

thanks in advance!

2 Answers, 1 is accepted

Sort by
0
Elian
Telerik team
answered on 16 Feb 2012, 04:53 PM
Hello Peter,

How many organizations can you have, is the number fixed on 2 or you can have infinite number?? 
If you can have more than 2, do you want all of them side by side or do you want only 2 at columns at each page?

If you always have only 2 companies it will be easier to have two tables side by side with different filtered data sources.
If you want all companies side by side this can be done with a crosstab by grouping on organization. 
If you want to have only 2 columns but have many organizations you can use Multi-Column Report layout.

Regards,
Elian
the Telerik team
Sharpen your .NET Ninja skills! Attend Q1 webinar week and get a chance to win a license! Book your seat now >>
0
Eric
Top achievements
Rank 1
answered on 01 Nov 2017, 07:43 PM
You did not answer the question, how can we have dynamic repeating tables exactly the same as the pictures he posted?
Tags
General Discussions
Asked by
Peter
Top achievements
Rank 1
Answers by
Elian
Telerik team
Eric
Top achievements
Rank 1
Share this question
or