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

Adding detail section in crosstab column group

3 Answers 87 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Mark
Top achievements
Rank 1
Mark asked on 26 Mar 2020, 01:19 PM

Hello.

I have a problem when adding details section in crosstab column group.

I once added it somewhen in crosstab row group but now when I'm trying to do this, 'Show detail data' is grayed out.

What I want to achieve is changing grouping from

Issue 1 

a

b

Issue 2

c

d

etc.

to

Issue 1 a b

Issue 2 c d

in a crosstab.

Anyone know how to do this? :) I'm attaching screen from group explorer window.

Thanks a lot in advance.

3 Answers, 1 is accepted

Sort by
0
Mark
Top achievements
Rank 1
answered on 26 Mar 2020, 03:03 PM
Ok I already made a workaround by adding rownumber column in my query and making crosstab columns based on rownumber rows.
0
Mark
Top achievements
Rank 1
answered on 26 Mar 2020, 03:05 PM
But still it will be nice to know how to solve my problem from main post. (why there is no edit option in forum? ...)
0
Katia
Telerik team
answered on 31 Mar 2020, 08:36 AM

Hi Mark,

Row group detail records are designed to be shown in rows, there is no out-of-the-box solution for showing them in columns instead.

I see that you have already come up with a workaround. Another workaround might be to concatenate the detail values of each row group in one column only. However, the width of the column needs to be adjusted manually in order to fit the values.

 

Regards,
Katia
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
Tags
General Discussions
Asked by
Mark
Top achievements
Rank 1
Answers by
Mark
Top achievements
Rank 1
Katia
Telerik team
Share this question
or