I have a relational database containing artists, songs, records (EP and CD), royalty agreement, sales etc.

I'm quite happy with the way it's working, however, I am running into some problems as I try to create some royalties statements, that can show me the total royalties generated per semester for each one of my artist.

I guess I should run a script to first select a period (for example 1st of January 2005 until 30 of June 2005), then sort it per artist, and other grouped data etc...

But because I would like to be able to control my cashflow whenever I want, I would like to have the option to kind of "simulate" the rapport.

Can anybody suggest a useful way to generate a report which would calculate these for me? I haven't been able to think of a way to make it work.

Any help would be appreciated.

You can create create a columnar/list layout using grouped data by artist name. In the end of creating a report, select the option to create a script to run the report. It would automatically create the sort script and navigating to the report layout.

Create a script where you can navigate to the find mode and pause and then ask the user to enter the date criteria for eg:

set error capture[on]

set user abort[off]

go to layout[find layout]

go to field[date]

enter find mode[pause]

perform find[]

if status(currenterror)=401

Show Message "No records found matching your search criteria"

else

Perform Script [script created in the first step]

end if

show all records