[Solved] Changing Counter Start Value

Getting your data onto paper - or the web - Discussing the reports features of Base

[Solved] Changing Counter Start Value

Postby One Big Yawn » Tue Aug 07, 2012 11:23 pm

I would like to assign each weekly report a sequential number based on the week it is produced (which will be generated based on parameters of beginning and end of the week, as there may be slight variation based on holidays). Our fiscal year begins June 1st, so it makes sense for that to be report 01.

Is there anyway to reset the counter based on the date? I thought I could use some sort of WEEK function, but this doesn't seem available in Base. :mrgreen:

Cheers
Last edited by One Big Yawn on Sat Aug 11, 2012 3:15 am, edited 1 time in total.
LibreOffice 3.5, MySQL 5.5, Windows 7
One Big Yawn
 
Posts: 24
Joined: Sat Jul 14, 2012 6:09 am

Re: Changing Counter Start Value

Postby eremmel » Wed Aug 08, 2012 11:08 am

Just a simple approach might be: populate a table with from/to dates and the week number. Use in the query the current_date to find the correct report/week number.
Is your question answered: edit your initial post add "[Solved]" to the subject and check V
LO4.2.8 for work with ORB; AOO4.1.4,LO5.2.5/6.0.5 on W7E SP1 64bit
It's Microsoft marketing that tells you computers are qualified for non-technicians
User avatar
eremmel
Volunteer
 
Posts: 1036
Joined: Tue Dec 30, 2008 1:15 am
Location: Barneveld, Netherlands


Return to Reporting

Who is online

Users browsing this forum: No registered users and 0 guests