Need your help, each month report

[Gejianwe]

My boss ask me to produce monthly report, each month appears horizentally rather than vertically, with the following format:

-------------------- Jan --------- Feb ---------- Mar ---------- Apr. ------------YTD
East region .................................................................................. .....Sum of YTD

North region -----------------------------------

West region --------------------


Can anyone shed a little light on this. I appreciate.

[NATHANI]

U can use cross tab format for this report
nothing else

hope it will solve your problem

[jggtz]

Also
You can use Formula fields

[jawadhashmi]

Cross TAB could be a good option.

But I will do it using Arrays or formula fileds. In one sub report I shall calculate all the values and in other I shall display them in a nice GUI.

This way it will be easy to manage and maintain the report.