Hi Paolo,
Well, I would not have noticed this if it where not raining in Denver
Colorado right now...LOL...in other words the National League Baseball
Playoffs game 4 is delayed. A man must have priorities.
Excellent, I am glad it helped. I'll check the wiki later so don't worry
about your entry there. If I see anything I can help with I'll do so
and let you know what I did.
Drew
Paolo wrote:
Hi Drew,
eventually I've tried your database (paolo.odb) and it works fine. So I've
changed my functions according to your example, and now they work fine on my
data as well!
What was causing the errors in the subtotal: I was using
[field]
alone as a starting value in the function definition; changing it to
IF(ISBLANK([field]);0;[field])
solved the problem.
I've registered to thw wiki, and I'll try and add this to share.
Thanks for your help.
Paolo
On Friday 12 October 2007 22:36:30 Drew Jensen wrote:
Hi Paolo,
I haven't updated the wiki pages, but for now.
You can download a database I have set up for you at
http://www.paintedfrogceramics.com/OpenOffice/SRB/Paolo.odb
In the database you will find a single report.
The report uses functions to create the sub totals, a grand total, for
records with NULL in the cost field the string NULL is printed in red on
the report. I believe it covers all the example cases that you have
asked about.
If you have questions feel free to ask. Meanwhile I'll update the page
at wiki with a small explanation of the steps in creating the report.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
