Im in the middle of creating a report using an ad hoc. However when it comes to grouping our data, we need to do this by week. Is this possiable or will need to look into a diffreant way of creating our report?
You can also use calculated fields in the domain to extract the week of the year from the date field and expose that as a field. You can read more about calculated fields in Chapter 6 of the Japser Server User guide ( http://community.jaspersoft.com/documentation ) and also in the JRS Ultimate Guide