RB filtering my recordset
I'm using RB STD 10.07, D7, DBISAM 3.26.
I am running a union query that joins three tables and results in 11
records, which I can verify by showing a grid prior to printing my report.
When I print the report, it is filtering out 3 records. It seem that it
ignores the first two unions.
What should I be looking for?
TIA,
John
I am running a union query that joins three tables and results in 11
records, which I can verify by showing a grid prior to printing my report.
When I print the report, it is filtering out 3 records. It seem that it
ignores the first two unions.
What should I be looking for?
TIA,
John
This discussion has been closed.
Comments
ReportBuilder simply traverses your data start to finish and displays each
record as it goes. If you take a look at your DBGrid, you should see the
cursor moving from top to bottom as the report generates. Is there any
event code present related to the report? If you place a new empty report
on your form, connect it to your datapipline and place a single DBText
connected to a field in your dataset in the detail band, do you still only
see 8 records?
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
I've narrowed the problem down. If I use a TppDBMemo and set the Stretch
property to true, and the field associated with this TppDBMemo contains no
data, the record is skipped completed, even though all other fields within
the TppDetailBand contain data.
John
Create a demo and send a copy to support.
Edward Dressel
Team DM