Hi all,
I'm a new user of Jet Report so I'm still trying to figure things out :)
I have a date range of May 10th 2014 to July 15 2014 and I want to get whatever sales amount happened in each month (10 May 14 to 31 May 14 & 1st Jun 14 to 30th Jun 14 & 1st Jul 14 to 15th Jul 14) but when I use the function to get the period of times, it only gives me the full month.
For example:
DateRange: 051014..071514
I want to get whatever sales amount happen in that period separated by month (filtered by Posting Date of Sales Invoice)
but when I use the NF to get the starting date and ending date of the period like this
"NF("Colums", "Date","Period Start", "Period Type", "Month", "Period Start",<DateRangeCell>" >> This one will give me 1st June instead of 10th May?
then for the last day of the Month I use "NL ("first", "date", "period End", "period type", "month", "period start", <BeginningDateCell>" in this case the BeginningDateCell is the one to be returned by the fomular above, and it will give 31st Jun instead of 31st May.
May I ask how to get the beginning and ending date of the period correct?
thank you in advance
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi Panda,
Perhaps this can help you?
Regards,
Gerard -
Jet Reports Historic Posts Or, if you prefer, this snippet might be of use :)
it's designed to allow for incomplete periods for a column report, as well as having a few other tricks:
The top left corner should go into cell A1
Period Start and End dates, as well as the period type (month, quarter, etc) should be entered in cells to the left
If a period is incomplete (a month not starting on the first, etc) - the column will have 'incomplete' on it and will be visible. If the period starts correctly, then the first column J will hide and the data will begin on column K.
If the end period is incomplete, again the column will have 'incomplete' on it and will be visible (otherwise it is hidden)
also - two types of row headers are provided, one will hide depending on if you are reporting for the month or a quarter. You'll have to do some tweaking for the incomplete month so it shows a correct header. My snippet was designed for reporting an on incomplete quarter or year…. :) -
Jet Reports Historic Posts Dear gjvk70,
It works really nicely, thank you so much :)
Dear Heather,
Thanks a lot, i'll check it out ^^
This Jet report is really useful, I'm hoping to explore more about it -
Jet Reports Historic Posts Hi Panda,
You are very welcome.
Jetreports is a great tool indeed. Started using it in combination with Navision but at this moment I am using it with several other ERP, HRM/Payroll solutions on SQL-Server.
Regards,
Gerard
Please sign in to leave a comment.