Joined: 07 Nov 2011
Location: Malaysia
Online Status: Offline
Posts: 3
Topic: Displaying data vertically based on month Posted: 15 Feb 2012 at 8:56pm
Hi I want to display data based on month vertically with some other data. I used crosstab table but it gives me funny result. Can anyone Please help me.
Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Posted: 16 Feb 2012 at 5:30am
from the looks of this crosstab doesn't seem like the right choice
try creating groups 1st manager name 2nd RepCode 3rd employee name
suppress details and place appropriate fields into group header 3
you would probably need to do summaries for months like
if table.date in date(2011,1,1) to date(2011,1,31) then sum(table.field to summarize,Emp name)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
