Report - Month as headers

[kastaman]

I'm in the process of creating a report which will show the monthly sum horizontally. Similar to excel. Can anybody provide some assistance on how I should design my report.

Thanks,

Kastaman

 

[gxd135]

If you have values across a report horizontally, you can add up all the values in a new text box. For example, if you have three fields across lets say the field names where x, y, and z respectively
Values in fields xy&z NEW TEXT BOX
23 45 78 =X+Y+Z
x y z
the field 23 is named X, 45 is named Y and 78 named Z. In the new text box where you want to see the sum type the above, =X+Y+Z would report the sum or 146

Let me know if you need any more help

g

 

[kastaman]

gxd135,

I was reading up on this and I guess I have to create a cross tab query first before I can set my report/form as such.

Kastaman.