>
>Even when it works, the "calculate it within the report" approach was somehow always disappointing to me. Very soon it would get into something that just can't be done that way, or would get too complicated, or (the worst) was actually needed somewhere outside of the report, so it had to be repeated in a different form. Which eventually taught me that having intelligent report is a fine but futile art. Preparing the data to report is, IMO, best done in a piece of code - SQL plus some grinding - and the display of the results is where a reporting engine should be in charge. Then if that code needs to be reused elsewhere (a bizobject? another report? grid with totals?), it can be.
I was (maybe still am) trying to create what you call "intelligent" report. And maybe it is futile. I will reply to Cathy Pountney's message with more explanation of what I am trying to do (since she asked).
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham