sort by c_monthyear

[RT]

hello back again for some help.

i have a report that is sorted by c_monthyear, it was working fine until 4 weeks ago. as you can see by the "reports.jpg below i get double months, and no july and other months. in the c_monthyear.jpg is the calculation. so i am saying the date of the invoice_date-4 i get a wrong calculation if i change it to invoice_date+4 it works or invoice_date0 any ideas as to why this is happening.

thanks

Robert

[comment]

Why would you subtract 4 (or anything) from the invoice date?

[RT]

we input all our time entries,every month on the last day of the month, so the invoices get generated on the 1,2,3 of the following month.

So by taking off 4 days from the invoice date we get a real representation for that months invoices otherwise everything in the report would be added to the wrong month.

[comment]

I don't know. I would guess your data is not what you expect it to be, but I would have to see the file to be sure.

[LaRetta]

Well, Robert, if you look at the data represented by that first August, I think you will find that the calculation is July (200707) and same with the October entry (the calc shows 200709) because it is kicking some entries backwards by 4 days).

Your leading part is based upon the calculation but the month name and year that you are displaying in the leading part are based upon date_invoice. Your calc is properly grouping but your display is wonkey because it moves some entries back to the prior month. It's splitting the data for you and then displaying it together again. At least that's my hit. :smirk:

Edited January 28, 2008 by Guest
Added sentence for clarity

[RT]

Thanks Comment and LarRetta,

i have fixed my problem, i copied the Fields from a back up copy, and re made the layout, rechecking the Summary sorts and it works now like it used to, thanks for your time.

RT