GROUP BY MONTH

How can I do for group by a DataItem of a Report by month? Example: Year Totals January 55 February 60 March 12 … Thank yor very much an so on, (more one year included).

Use the “Date” table. By using it as a DataItem and filtering on “Date Type” and “Start/End of Period” (field names translated from German…), you can generate and iterate over months, years, weeks, days etc.

quote:


Originally posted by xorph
Use the “Date” table. By using it as a DataItem and filtering on “Date Type” and “Start/End of Period” (field names translated from German…), you can generate and iterate over months, years, weeks, days etc.


What number has “Date” table? I try to insert int in my Report, but appear “Date Compr. Register” Can you Help me?

Hey the date table has number 2000000007. Fred[:D]

quote:


Originally posted by FredBergmann
Hey the date table has number 2000000007. Fred[:D]


Thank you, I’ve really appreciated your help!

quote:


Originally posted by t.nori

quote:


Originally posted by FredBergmann
Hey the date table has number 2000000007. Fred[:D]


Thank you, I’ve really appreciated your help!


Does exist any standard Report that use this table? Can you send me any example code? Thanks Thomas[8D]