I like your final solution for a calendar. I've implemented a calendar like this in a jasper report (on Oracle), with hyperlinks to actions on that date . Your

I like your final solution for a calendar. I've implemented a calendar like this in a jasper report (on Oracle), with hyperlinks to actions on that date . Your SQL is cleaner to read. However on my environment the week numbers don't line up correctly. I had to change the line , TO_CHAR(x +1, 'iw') weeknumber , TO_CHAR(x , 'iw') weeknumber I guess this might be environmental as some regions may consider the start/end of the week on different days.