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

Wrong data in report

edited October 2008 in Datapipelines
Hi,

I'm using Delphi 2007 using ReportBuilder 10.07.

I have a problem with wrong data being displayed in the report.
On the datamodule I have a few queriies, and matching datasources.
On the form with the report I have matching DataPipeLines.

The queries use parameters to narrow the records to a specific date of
orders. In the datamodule I have specified a certain date to see if it
works.

When I walk through the resultset of the query of the datamodule, the
application gives me the correct records. BUT .... the report is showing
the records with the specific date mentioned above.

Can someone tell me what I'm doing wrong ???

I'm using mySQL

The query on the datamodule shows 1 record, but the report prints 2
other records.
So no, the number of records is not correct.
AND ... the records displayed are also not correct.
The report prints the records found by the query with the default
parameter (set in the datamodule)

Example : select * from orders where date_order=:date_selected
In the datamodule "date_selected" = 20080205
When executing the report the parameter "date_selected" is set to
20081023
Showmessage of the details of the orders gives 1 record ==> 20081023
The report prints 2 records ==> 20080205

DataPipeLine of the report is connected to the DataSource of the
datamodule, DataSource is connected to the query above.

Thanks for looking into this strange behaviour.

Benny.



--- posted by geoForum on http://delphi.newswhat.com

Comments

  • edited October 2008
    Hi Benny,

    For future reference, please use your real name when posting to these
    newsgroups.

    It sounds like the date_selected parameter is not being set to the proper
    value as the report prints. Where are you setting the parameter value?
    Note that ReportBuilder simply traverses the data it is given. If you are
    seeing incorrect data, this means the data being sent by the connected
    dataset(s) is incorrect.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.