RB doesn't work with Query

rbuser

Hello, my repport doesn't work with query, the data doesn't appear....when a
use the same report with a table, work fine! whats the problem!?

thanks for all and sorry my poor english

[]s
Fellipe Henrique

nicocizik

Hi Fillipe,

ReportBuilder treats Tables and Queries identically. It simply uses the
DataPipeline to traverse a TDataSet descendent and displays that data on
your report. Are you certain your query object returns any data? Try
connecting it to a DBGrid and see if the data displayed is correct.

--
Regards,

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

rbuser

Yes, the query return many data, its estrange but in my aplications, never
works with query. I set some parameters for work these?

thanks

nicocizik

Hi Fillipe,

This is not a known issue with ReportBuilder. TQuerys should work the exact
same as TTables.

As a test, try creating a simple application consisting of a TQuery
connected to the DBDEMOS database, a TDataSource connected to the TQuery, a
TppDBPipeline connected to the datasource and a TppReport connected to the
datapipeline. Then design the report to desplay one of the fields in the
query. When you preview this report, you should see the data.

--
Regards,

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

rbuser

It's works, but my problem is... I have one TIBQuery, and I make the SQL
runtime, and do not appear data.... I make these:

with IBQuery1 do
begin
SQL.Add('select * from clients');
SQL.Add('order by Name');
Open;
end;
Report1.Print;


thanks

nicocizik

Hi Fellipe,

Please send a simple example of this in .zip format to
support@digital-metaphors.com (including your database file) and I'll take a
look at it for you.

--
Regards,

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

rbuser

Hi Nico,

I sorry for these incoveniense, but it's works now, the problem is when I
do not close TIBQuery, before in procedure....!

thanks for alll!