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

It?s show several times the same registration?

edited December 2001 in General
Hello,

Why the times just existing a registration in DataSet, does the ppReport
show several times the same registration? This also happens when I have 2, 3
...4 registrations.... he always shows the first.

It is suddenly, he is OK!

???

D6/RB 6.03

Thank you,

Comments

  • edited December 2001
    Connect the dataset to a dbGrid on a form to see what records the dataset is
    returning at runtime. Is this master-detail? Is the data pipeline connected
    to the Report.Datapipeline property?


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited December 2001

    is
    Yes. Before the user to click in the button of printing he visualizes in a
    GRID the registrations.

    No. Simple Table.

    Yes.

    The most interesting than I see the same to work just changing the property
    OpenDataSource!

    D6 SP1, RB 6.03, DBExpress with SQLDataSet+TDataSetProvider+TClientDataSet.

    Thanks
  • edited December 2001
    Ok, you've got it. I see, you have the query open when the report is going
    to run. The dataset needs to be closed before the report runs. By setting
    OpenDatasource you are forcing the datapipeline to close the query and then
    reopen it so that it starts fresh from the first record.


    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.