How to center a cross tab report on a page 1

[lgard3]

Hi. I am relatively new user of Crystal Reports. I am currently using Crystal Reports 11.

I have a report w/ a cross tab report on the tab that displays # of tickets by category. We have 7 different categories. On some days, we may have only created tickets under 2 categories. On other days, we may have created tickets under all 7 categories.

Every day my report looks different based on how many categories there are tickets under. Today - I had so many categories that it went over to the next page!

I suppose I could put the cross tab report all the way over to the left side of the page. That way if there are 7 categories, it should all fit, but on days when there are only 1 or 2 categories it seems like it will look strange on the page.

I do not see or find anywhere an option to "center" a cross tab report.

Is this possible? Even w/ the use of formulas perhaps?

Thanks in advance for your help!

 

[lbass]

Select the crosstab->format->size and position->x->x+2 formula area and enter something like:

if distinctcount({table.columnfield}) > 5 then
0 else
if distinctcount({table.columnfield}) in 3 to 5 then
2000 else
if distinctcount({table.columnfield}) in 1 to 2 then
4000

Adjust as necessary--the numbers refer to twips.

-LB