Crystal Reports Cross Tabs Formatting Column Widths

You can size individual columns in  your crosstab with the cursor.  Simply click the colum, hover over the right-hand side of the column and drag it so that it fits the content of the field.

~Kurt

Actually, if you expand the size of one column as Kurt suggests, it will change the size of all of the columns.  To the best of my knowledge there is no way to change the size of one column to be different than the others.  The summary and header columns are sized independant of the data columns but all of the data columns maintain a uniform size and there is no workaround I'm aware of.

frodoman

I just tested this in Crystal Reports 10 and 11, frodoman.   The key is to size a column based on the field at the row level, not the column itself.

~Kurt

Maybe new feature in 10?  I've got 9 on my laptop where I'm working and that doesn't work here unless I'm misunderstanding (if I select an field in the data area they are all selected automatically and changes applied to all of them).

Good to know though - thanks Kurt

How do you size a column based on the field at the row level not the column itself?  Sorry but I am not understanding how to do what you suggest?

I think it is version-specific.  In CR 8.5, I have two types of summaries for a row:  Sum of Orders and Count of Orders.  In 8.5, the two summaries are loaded into the same column, one on top of another.  In CR 10 and 11, however, these values are loaded side-by-side, which means their widths can be controlled independently.

~Kurt

If you have the sample reports installed, open the CrosstTab sample, which is typically located at C:\Program Files\Crystal Decisions\Crystal Reports 10\Samples\En\Reports\Feature Examples.  The report should open with saved data.  Highlight the very first record, which will be $23,612.06 for the Row "Descent" in the 1/100 Column and SUM of Orders sub-column.  Once you have this field highlighted, you can use the widget on the right-hand side to resize it.  You'll noticed that even though you resize this field, the width of the Percentage of Orders sub-column will not change.

~Kurt

recommend split:  rhinok & frodoman