>
>DETAIL 1 - has Data
>DETAIL 2 - has no Data
>DETAIL 3 - has Data
>DETAIL 4 - has no Data
>DETAIL 5 - has no Data
>
>Report Writer calculates the remaining space on the Page as if DETAIL 2, DETAIL 4 & DETAIL 5 have Data and forces an empty extra page.
>
>Anyone found a workaround for this?

Not exactly 'workaround' and could be a even overkill if this is only multi-band report you have
but If you do multi-band reports more often, then you should take a look at www.report-sculptor.com

With RS you can build these complex multi detail band reports using form designer and using form containers as report bands.
Then you run those containers as report from your own code which gives you almost absolute control over page creation.
RS have properties like PageHeight, PageWidth, PageRemainder etc which you can use to determine if band will fit into page
and then execute it or not. eject page or not etc.

It is basically cross between code reporting and visual report design and whole new paradigm of free report creation if you wish.
You can have report consisting of 3 details bands presenting 3 related or unrelated tables, then few free WYSIWYG pages
then some tables/bands again, then page with some activeX graphs maybe etc.

Since it is you who drive report rather then FRX engine, then you might find data preparation much easier (elephant SQL statements...)
as you no longer need to satisfy FRX engine dataflow/model but rather building freely your own reporting model/pattern
according to report layout/content you want to create. For example, in above mentioned reporting of multiple unrelated tables
you can use natural data rather then joining them into one big cursor to satisfy multi-band FRX.
And so for :)

This post is almost like a little teaser :) but might help you grasp some possibilities that might not be obvious immediately after hitting the link. See samples above #10 in RS demo project for hints/ideas.

HTH
Sergio