Limit size of cross tab columns

[jbarbato]

I am using Crystal XI against an Oracle 10g db...

Is there any way to make columns smaller in crosstabs? I am getting the information I want, but I cannot make the crosstab small enough to be of any value. All of the columns are way bigger than the data they hold.

Thanks!
- Jayme

 

[synapsevampire]

You can drag them and shrink them down, however they tend to size to the largest field.

Perhaps you have some padded fields?

You can use a formula in lieu of the field to trim them, such as:

trim({table.field})

Or use a SQL Expression on the field (performed by the database so it's faster) to ensure that they're trimmed.

You might also select a smaller font if it is an issue with the largest column being very wide.

-k

 

[jbarbato]

yes i found all of that, thank you!

my problem was that I had "Lock Size and Position" On the cross-tab for some reason. I was not able to modify anything!