cancel
Showing results for 
Search instead for 
Did you mean: 

can grow for cross tab

Former Member
0 Kudos

Hi All,

I have a cross tab report having some columns.

But when the length is not enough my columns are cutting.

I need to apply can grow which is disable.

Please suggest

Accepted Solutions (1)

Accepted Solutions (1)

raghavendra_hullur
Active Contributor
0 Kudos

Hi,

Crosstab fields will not have "Can Grow" option as the crosstab automatically tries to adjust based on the values.

Can you share the screenshot?

Thanks,

Raghavendra

Former Member
0 Kudos

Hi Abhilash and Rgha,

PFA.

Every time I will have only 3 values for Activity ids

Some times I will get 40 characters of data for ratings.

And I need to fit this cross tab report in one page only(it should not increase width).

Please help

abhilash_kumar
Active Contributor
0 Kudos

Would you be able to share the report with saved data please?

-Abhilash

Former Member
0 Kudos

Hi Abhi,

PFA.

raghavendra_hullur
Active Contributor
0 Kudos

Hi,

If you opt for Landscape page layout, you can accommodate more width for each of those 3 fields.

But in case you don't want to do that, you have to increase the width manually as Abhilash suggested as in attached sample report.

I have modified the formulae to include 50 characters as you can see in the output.

Thanks,

Raghavendra

abhilash_kumar
Active Contributor
0 Kudos

Like I said, only workaround is to manually increase the height and width of the summary cells.

Since you're always going to have three columns, you should create a Manual Crosstab as outlined in this example:

Crystal Report - Mock Crosstab

or this (Crystal report for Enterprise):

-Abhilash

Former Member
0 Kudos

Hi Raghav,

What you did.

How the text is coming to 2nd line ? I am confusing .can you please explain ?

abhilash_kumar
Active Contributor
0 Kudos

Manually increase the height of the summary field and the data should wrap onto a new line.

-Abhilash

raghavendra_hullur
Active Contributor
0 Kudos

Hi,

Yes as Abhilash explained it's just increase in the height of Summary fields and this will accommodate approximately 60 characters.

If those 2 formulae are going to have more than 60 characters, again, the text will be cut.

So, if you still need "Can Grow" option, then as per Abhilash's content, you have to go for a mockup Crosstab.

Thanks,

Raghavendra

Former Member
0 Kudos

Hi Abhilash,

So my field is going to occupy some 5 lines.and Sometimes if it is only 1 line of data only so the blank space for height will remain same.

Yes ?

raghavendra_hullur
Active Contributor
0 Kudos

Yes Divya. 5 rows will remain irrespective of whether you have 1 line data or 5 lines of data.

Thanks,

Raghavendra

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Divya,

The functionality does not exist at the moment.

Please go ahead and vote for this Idea :

https://ideas.sap.com/ct/ct_a_view_idea.bix?c=A5E8DEA8-D886-4250-BA2B-039F7D32FFC0&idea_id=123116E8-...

Only workarounds available at this point:

1) Manually increasing the size of the field

2) Building a Manual Crosstab. A Manual crosstab, however cannot have dynamic columns, so you need to know how many columns your crosstab will have as they have to created manually.

-Abhilash