Cross-Tab Amount Field (Don't want fixed decimal places)

[SonOfZeus]

I've developed a report with numerous cross-tab reports within it. The problem I have is space in the cross-tab, such that with varying sizes of numbers causes column overlap. Is there a way to print the cross-tab amount with the minimal decimal places for the amount.

i.e.

1200.00
8.25

would become

1200
8.25

If not, can one make the columns adjust in width to the size of the largest number in the column

 

[lbass]

Right click on a summary in one of the cells->format field->number->customize->decimal->x+2 and enter:

if val(right(totext(currentfieldvalue),2)) = 0 then 0 else
if val(right(totext(currentfieldvalue),1)) = 0 then 1 else
2

This assumes that the maximum decimals you want is 2.

-LB

 

[SonOfZeus]

This works great thanks, now all I've got to do is find a way to put a tiny cell margin between columns(default is way too big), is this property somewhere easy to find?

 

[lbass]

You can eliminate margins by going to the customize tab->uncheck "show cell margins". This gives the cells sort of a cramped look though. How about changing the font size instead?

-LB

 

[SonOfZeus]

I want margins, but not the default size. Changing font to force the space may work but dropped bold & size one on total. Think the issue is that I've a border on the summary above, but need a border on bottom of last item before summary instead..