How to dynamically resize the columns of a cross - tab

building reports crystal reports
1

Hi,

I created a cross tab report with Type and count.
i updated the first column Display String as "Type " + CurrentFieldValue. some of the description in the CurrentFieldValue is coming more than width of the row and it is not getting displayed. And the option that allows a field to grow is disabled which is not allowing a field to grow dynamically.

For Example:
If one of the type is ‘Dcnt’
The report should like

Total A : 60 Total B : 12 Total C : 25 Total Dcnt : 12

and not like as below:

Total A: 60
Total B: 12
Total C: 25
Total Dcnt : 12

When i am trying to display the field Total Dcnt, It is getting truncating and i could not able to display “:” also in a same position for all the records, i.e, the colon should be the last which should be aligned for all the records according to greatest length of the row. In this example Total Dcnt is the maximum length, so the colon should be aligned according to its length.

Can you please kindly let me know how to fix this issue.

Thanks!!!
1.txt (0.0 KB)

Chandran21 (BOB member since 2009-09-14)

2

It may be that Autofit can’t deal with your formula that combines a String and a Number. It may help if you convert the Number to a String. See FormatNumber().

pcgeekus :us: (BOB member since 2003-10-16)

3

I tried to do the formatting but the Format field options itself id disabled.
Kindly let me know if we can resize the column of a crosstab.

Chandran21 (BOB member since 2009-09-14)

4

Do the FormatNumber and concatenation in a Variable and use that in the column instead.

pcgeekus :us: (BOB member since 2003-10-16)

5

Thanks!!!

Chandran21 (BOB member since 2009-09-14)