Cross tab printing behavior

[sk8er1]

I have a cross tab report thanks to the help of this group. Its working fine, there is one thing I would like to try to change...

1/2 1/3 1/4 1/5
---- ---- ----- ----
ABC
CDE
EFG
HIJ

What I would like to have is the two items for column 1/3 to
be directly under each other without the white space.
Is there a setting in the format for this...

Thanks so much

 

[lbass]

Is this a manual crosstab, e.g., did you create it using formulas? Or did you insert a crosstab? If the latter, what was your row field and your summary field?

-LB

 

[sk8er1]

I used a formula field for the date column and a table field value for the row value. The summary field is
Nth most freq(N=1)of spRptFieldName

Hope this helps

 

[sk8er1]

For the column data if the row value is null, then I display it in the current date column....

 

[lbass]

So, is this an inserted crosstab? Please provide the name of the row field and the name of the summary field, and state the section in which you have placed the crosstab. If it is a group section, identify the group field.

-LB

 

[sk8er1]

Yes, it is an inserted crosstab. The name of the row field is Railcar, and the name of the column is @ActDelivDate.
THe summary field is ...count of Nth most freq(N=1)of spRptFieldNameRailCar.

The crosstab was placed in the header section.
Hope this helps...

 

[lbass]

The report header or the group header? I'll assume the report header. Try eliminating the RailCar row field, and, instead, enter the RailCar field multiple times as the summary field--up to the maximum number of railcars that could appear per day--each time incrementing the N in NthMostFrequent by one. This would at least cluster the results in the top lines, although you would have empty cells for higher N's.

-LB