Hello There,
I'm looking to build a report that has data fields retrieved on monthly bases, but the way is the fields sort down( on the left side of the report) and the month names are across( on the top of the report)

the code I have written:
TABLE FILE CALLS
SUM ONLINE_REQUESTS AS 'Online'
EMAIL_REQUESTS AS 'Email'
.
.

BY Month NOPRINT
ACROSS Month

the result I'm getting is the month names and data fields are repeated across the page, what is the way to not repeat the field names across the page.

thank you in advance!

This message has been edited. Last edited by: Badr.A,

Are you looking for something similar to this ?

DEFINE FILE GGSALES
MTH /M  = DATE;
MTHX/Mt = DATE;
-* For long month name
-*MTHX/Mtr = DATE;
END
TABLE FILE GGSALES
SUM DOLLARS
BY REGION
BY CITY
BY PRODUCT
ACROSS MTH NOPRINT
ACROSS MTHX AS ''
END

Note that the ACROSS MTH NOPRINT is there to keep alpha month displayed in a calendar order and not in an alphabetical order.

I'm looking to arrange the fields by the months (BY Month) and at the same time need the month names to be ACROSS!
thank you

quote:

Originally posted by MartinY:
Are you looking for something similar to this ?

DEFINE FILE GGSALES
MTH /M  = DATE;
MTHX/Mt = DATE;
-* For long month name
-*MTHX/Mtr = DATE;
END
TABLE FILE GGSALES
SUM DOLLARS
BY REGION
BY CITY
BY PRODUCT
ACROSS MTH NOPRINT
ACROSS MTHX AS ''
END

Note that the ACROSS MTH NOPRINT is there to keep alpha month displayed in a calendar order and not in an alphabetical order.

quote:

I'm looking to arrange the fields by the months (BY Month) and at the same time need the month names to be ACROSS!

Will make a strange output, but...

DEFINE FILE GGSALES
MTH /M  = DATE;
MTHX/Mt = DATE;
-* For long month name
-*MTHX/Mtr = DATE;
END
TABLE FILE GGSALES
SUM DOLLARS
BY REGION
BY CITY
BY PRODUCT
BY MTH AS 'Month'
ACROSS MTHX AS ''
END

I think it wont be done

thank you!

quote:

Originally posted by MartinY:

quote:

I'm looking to arrange the fields by the months (BY Month) and at the same time need the month names to be ACROSS!

Will make a strange output, but...

DEFINE FILE GGSALES
MTH /M  = DATE;
MTHX/Mt = DATE;
-* For long month name
-*MTHX/Mtr = DATE;
END
TABLE FILE GGSALES
SUM DOLLARS
BY REGION
BY CITY
BY PRODUCT
BY MTH AS 'Month'
ACROSS MTHX AS ''
END