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

Subreport spanning row groups and column groups in crosstab

4 Answers 22 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Phil
Top achievements
Rank 1
Phil asked on 25 Jul 2017, 06:48 PM

I have a cross tab where I would like to have a sub report that spans across the row groups on the left and across all column groups on the right.  This is tough because I don't know how many columns will end up because it depends on my data.

Is there anyway to make a sub report span row and column groups that it is flush with the left and right borders regardless of the number of columns?

4 Answers, 1 is accepted

Sort by
0
Katia
Telerik team
answered on 27 Jul 2017, 12:16 PM
Hello Phil,

You can test using automatic layout options such as Docking and Anchoring - Automatic Layout (Dock and Anchor). A Panel item can be used as a container for the crosstab and sub reports.

If your layout is more complex attach some screen shots that demonstrate the exact requirement.


Regards,
Katia
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
0
Phil
Top achievements
Rank 1
answered on 27 Jul 2017, 07:19 PM

Thanks for getting back to me, Katia.

I added a screenshot (This is just a mock-up of the report and how we want it to look).

It is a crosstab and on the left side of the vertical red line are the column groups with a variable number of columns depending on the data.  On the right side of the vertical red line are the static columns.  The area with the head 'Note', which is outlined in blue, is where I am having the problem.  We want this portion to be grouped in the same row group as the item above, but we want it to span however wide the crosstab will be.  We don't know how wide the crosstab will be until the user selects from parameter values and runs the report.

Is is doable to have the 'Note' section span the entire crosstab despite the number of columns that are output?

Thanks,

Phillip

0
Accepted
Katia
Telerik team
answered on 31 Jul 2017, 02:25 PM
Hello Phillip,

The Note section demonstrated in the attached mock-up cannot be created within the same Table/CrossTab item as cells from different column groups cannot be merged.

My suggestion is to use a separate Table item to display the Note section and set its anchoring properties so it can be resized according to the width of its container. The attached report demonstrates this approach.

Another approach can be to change the width of the table that displays the Note section at runtime based on the received data. This can be achieved by adding a binding for table's properties into Bindings collection of the Table item.


Regards,
Katia
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
0
Phil
Top achievements
Rank 1
answered on 02 Aug 2017, 04:52 PM
Thanks, Katia.  Very well explained as usual.
Tags
General Discussions
Asked by
Phil
Top achievements
Rank 1
Answers by
Katia
Telerik team
Phil
Top achievements
Rank 1
Share this question
or