Wrong data in report

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.

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

nicocizik

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