Wrong data displayed

rbuser

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.

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.


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

Thanks in advance,
Benny.



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

rbuser

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

just to confrim, it sounds like you are getting your data from the data
module, and not using DADE. Correct?

nicocizik

This question was answered in the Datapipelines newsgroup. Please do not
cross post.

--
Regards,

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