0

Grouping by date

Jet Reports Historic Posts

May 26, 2009 14:05

None

Follow

Hello all,

does anyone know how to group by date, namely by month or year? I can group report by customer and product number, which is OK. I know how to group by date, but that is particular date, but I need grouping by months and years…

Thanks for your hints!

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts May 26, 2009 15:27

  The secret to grouping by date begins with using date ranges in your filters, for example
  
  Jan 09 - nl("Datefilter","010109","013109")
  
  or inside an existing NL function nl(…., "Posting Date","010109..013109")
  
  You can then expand on that to include any date range you wish.
  
  Secondly to that, I often use Excel and the rows functions to automatically create the date ranges I'm looking for, such as using a calculation to automatically generate the date based on the row number. Or you can build a list in excel and use NL("Rows",<cell range>) to do the grouping.

• 0
  
  Jet Reports Historic Posts June 03, 2009 15:17

  Hope that the attached report speaks for itself…
  
  Allot of jugling with dates to get the correct results :evil:
  
  Could even be expanded to Year-Quarter-Month-Week-Day 8-)

  • Year-Month.xlsx
• 0
  
  Jet Reports Historic Posts June 03, 2009 15:28

  You should look at the following topic
  
  http://community.jetreports.com/viewtopic.php?f=7&t=562
  
  This gave me the idea of using
  
  =NL("Rows","Sales Header","=Local(TEXT(NF(,""Posting Date""),""YYYY-MM""))")