Printing Problem

rbuser

Hi,

I have a problem with a combined report.
All reports are created in the database.
RBuilder version: latest 7.x
Delphi 7
SQL Server 2000

There are 2 independent datasets.
The first dataset shows all the sales which have amount <> 0
The second dataset shows all other sales (amount = 0)

The main report shows the first datast.
In the summary, I have a subreport which shows the second dataset.

I have the following problem now:
for a given day i have only sales with amount = 0
So the second dataset should be showed.
But ... since the first dataset is empty, the whole report is blank.

I guess this must be a 'No data' problem, but don't know how to solve it
right now.
Also mentioning that there is no code that can be processed since the report
is designed in the database.
The only code I can write is RAP code.

Regards,
Wouter Devos
XLent Solutions

digitalmetaphors

You'll have to set the Report.NoDataBehaviors to [ndBlankReport]. However,
sets aren't supported in RAP, so you'll have to code a RAP pass through
function to set this property from RAP.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim,

[ndBlankReport] ???
Will this show my data in the summary band when my second dataset has data
and the first one does not?

I'll give it a try this evening and keep you informed about it.

Regards,
Wouter Devos

digitalmetaphors

Yes, it will show the header, footer, empty main detail and the summary will
get to generate completely over its dataset.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim,

Thank you so much!
My client was asking about this 'feature'. "When there are no sales at all,
just let me see the page ...'
I think you've solved my problem here too.

Regards,
Wouter Devos