I have a graph that has days across the x-axis. I want the days to display as 1, 2, 3 but they display as 1.00, 2.00, 3.00. The format in the database is integer, but shows as D20.2 in web focus. Here is the code I am using:

GRAPH FILE REPORT_SHORTFALLS
SUM REPORT_SHORTFALLS.SHORTFALLG
ACROSS REPORT_SHORTFALLS.CDAY

Any help is appreciated.

DEFINE FILE REPORT_SHORTFALLS
CDAY_I/I4 = CDAY;
END

GRAPH FILE REPORT_SHORTFALLS
SUM REPORT_SHORTFALLS.SHORTFALLG
ACROSS REPORT_SHORTFALLS.CDAY_I
END

Was the Master generated from the server console? It is curious that an integer field was converted to D20.2.

Thanks a lot. That was killing me.

I actually had to use this to get it to work:

DEFINE FILE REPORT_SHORTFALLS
CDAY/D20 = CDAY;
END

Thanks again