Can I force column break?

[lester50]

Having never used column, I do not know if this will work..

I need to print info by date, so records contain:
month
day
qty

The report would show:

Day Jan Feb Mar
01 x x x
02 x x x

The report should show days as rows and months as the columns with the qty in the details. Since months have different days, is there an easy way to force a column break so it prints the next item at the top of the next column (say March 1), so it prints in the day position rather than after Feb 28 in the day 29 position?

Thanks, jlester@lester.com

 

[kenhamady]

You can't force a column break in details.

You could use a cross-tab based on two formulas:
Use the Month(date) for the columns.
Use the Day(Date) for the rows.

You could also use a manual cross-tab, described in my FAQ on common formulas (in the general forum). Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)