I have a report that is a payroll history report.  It's a report that shows an employees pay history information by paycheck.

 

I've used a sub report for the ben/ded information and I pull that information from a SQL view that I've created.

 

Inserted into the main report, it currently looks like this:

 

aetna   100.00

hlth1      25.00

medc      50.00

fica       100.00

dentl      25.00

ss         150.00

iawt        53.00

garn      100.00

 

Depending on the employee, department, pay period and number of ben/deds the list may be as few as 5 items or as long as 15.  On the longer lists it creates a lot of white space on the report.

 

My question is:  is it possible to have the sub report start a new column after a set number such as 4 items in the list has been reached?

 

Example:  What I'd like to see if the number of ben/deds is greater than 4 is: