PRoblem with sql and reportbuilder

rbuser

Hi!

I have a query with this sql statment:

select b.numdias,b.juros,b.liquido,b.codcq,b.codtrans,t.datatroca,
t.codtrans,t.juros,t.liquido,c.vencimento,c.valor from bordero
b,transacao t,cheques c
where b.codtrans = t.codtrans
and b.codcq = c.codck

and I've put a ppreport component and linked it to a dbpipeline.I have
designed my report and add dbfields to be filled with my DB information.

In my Field Juros I have set the property datafield to b.juros, but it
is not showing.

What is the problem?

Thank You!
Eduardo Tavares

nicocizik

Hi Eduardo,

1. Where is your DBText component located? In order to show traversed data
it will need to be located inside the detail band of a report.

2. Be sure the datasource is connected to the report (Report.Datapipeline
property).

3. If you connect your dataset to a Delphi DBGrid, is there actually data
in the b.juros field? Are any other fields showing up in your report?

--
Regards,

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

rbuser

Hi Nico, first of all thank you for your help.

1:Yes it is inside details band.
2:Yes the datasource is connected
3:Yes there are data in my database, and others dbtexts are showing
data, only two dbtexts arent showing.


What can I do ?

thank You

nicocizik

Hi Eduardo,

ReportBuilder simply traverses the data given to it and displays it on the
report. Let's try to simplify and see if we can track down the problem. As
a test create a simple application containing a query that only selects the
juros field from the b table, a DataSource, a DBPipeline, and a TppReport.
Connect all these components correctly and try running your report which
contains a single DBText linked to the juros field. Are you able to see any
data? If so, slowly begin enhancing the SQL so that it eventually is as
complex as the original and see if you can still view the DBText.

--
Regards,

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