Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

RB filtering my recordset

edited October 2007 in General
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

Comments

  • edited October 2007
    Hi John,

    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited October 2007
    There is no event code etc.

    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

  • edited October 2007
    > I've narrowed the problem down. If I use a TppDBMemo and set the Stretch

    Create a demo and send a copy to support.

    Edward Dressel
    Team DM
This discussion has been closed.