Getting all records in a range...
Hi,
I'm using RBPro 5.56 and I'm having the following problem:
My app uses three FlashFiler-tables: Dos (fields: dosnr), DosClient (fields:
dosnr, clientnr; ...) and DosClientContacts (fields: dosnr, clientnr,
clientcpnr, ...).
The Dos-table is the main table with DosNr as keyfield. The DosClient-table
has the fields DosNr and ClientNr. In the AfterScroll event of Dos, there's
a range on DosClient (with the field DosNr).
The records retrieved by the range are put in a subreport. So far so good!
Now, the DosClientContacts is connected to DosClient. In the AfterScroll
event of DosClient, there's a range on DosClientContacts (range on dosnr and
dosclient).
These records are also put in a subreport in the subreport of DosClient.
But when there are no records for a DosClient in DosClientContacts, that
record is also excluded from the DosClient subreport, thus only the records
of DosClient that have records in DosClientContacts are printed.
I'm using groups, I've tried mastersource and SetRanges but nothing will do.
Is there someone who can tell me what I'm doing wrong?
Gerd Moors
I'm using RBPro 5.56 and I'm having the following problem:
My app uses three FlashFiler-tables: Dos (fields: dosnr), DosClient (fields:
dosnr, clientnr; ...) and DosClientContacts (fields: dosnr, clientnr,
clientcpnr, ...).
The Dos-table is the main table with DosNr as keyfield. The DosClient-table
has the fields DosNr and ClientNr. In the AfterScroll event of Dos, there's
a range on DosClient (with the field DosNr).
The records retrieved by the range are put in a subreport. So far so good!
Now, the DosClientContacts is connected to DosClient. In the AfterScroll
event of DosClient, there's a range on DosClientContacts (range on dosnr and
dosclient).
These records are also put in a subreport in the subreport of DosClient.
But when there are no records for a DosClient in DosClientContacts, that
record is also excluded from the DosClient subreport, thus only the records
of DosClient that have records in DosClientContacts are printed.
I'm using groups, I've tried mastersource and SetRanges but nothing will do.
Is there someone who can tell me what I'm doing wrong?
Gerd Moors
This discussion has been closed.
Comments
this seems to be a FlashFiler problem that has come up before. It seems to
be related to the lack of outer joins in the actual version. I'm not totally
sure, so perhaps you should ask the gurus in The FF NG.
--
elektronik-labor Carls GmbH & Co. KG
Stefan Paege
Kontakt: +49 (0)5973 9497-23 Fax: +49 (0)5973 9497-16
Thanks for your advice. I've made a little program with 3 DBGrids,
containing the 3 tables. When I scroll through the main table, the other 2
are updated, just like it should be. Maybe the problem is how FlashFiler
communicates with ReportBuilder?
Greetings,
Gerd Moors
how is the data setup in your report? I was assuming a SQL-based solution.
Is this the case? If it is not I led you on the wrong path. Please clarify.
--
elektronik-labor Carls GmbH & Co. KG
Stefan Paege
Kontakt: +49 (0)5973 9497-23 Fax: +49 (0)5973 9497-16
sorry for bothering you, but I've overlooked a property of the ppDBpipeline
object -> SkipWhenNoRecords. Setting this to False, gives me the missing
records.
We're not using SQL but just tables with ranges to obtain the data for the
report.
Thanks again for the tips.
Gerd