One way calendars appear when there are five weeks needed is to display the last two days of the month on the first line of the calendar.

First you will need to change the conditional display string of the Sunday on the first row to

if {@Sunday} < {@Start of Month} and {@Sunday} + 35 <= {@End of Month}

then totext({@Sunday}+ 35,"dd-MMM-yyyy")

else totext({@Sunday},"dd-MMM-yyyy")

Then change the conditional font color to

if {@Sunday} < {@Start of Month} and {@Sunday}+35 > {@End of Month}

then silver else black

You need to change the first two running total fields. The conditional evaluate of the First Sunday is

if {@Sunday} < {@Start of Month} and {@Sunday}+35 <= {@End of Month}

then {GLTrans.TRDate}={@Sunday} + 35

else {GLTrans.TRDate}={@Sunday}

Do a similar change to the First Monday in your calendar. As the month can only wrap two days in the top row, you don’t need to make any changes further along the row.

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.