Design time OK, Run time no data

rbuser

At design time I can click on the Preview tab and see every record in my
database. However, at run time the Preview screen shows "Accessing data ...
" at the bottom left and never shows any report. Clicking on the Cancel
button does nothing, I have to use Ctrl-F2 (in debug mode) to kill the
program.

I'm using Delphi 5, Report Builder 6.01, and Advantage DB 5.7. I'm using a
TAdsQuery component to get my data.

I'd sure appreciate any suggestion about what I'm doing wrong.

Thanks,

Mike

digitalmetaphors

The first thing to test is to make sure you are getting the data at runtime.
Hook the datasource that the datapipeline is conected to, to a TDBGrid on
the form. This should show the records at runtime. Is there anything else
that you are doing in code that could affect the query? Most likely the
delay is a problem with on e of the calcualtions you have for your report?
Can you provide more information on what the event handlers for this report
are calculating? Try commenting some of them out, incrementally, in order to
isolate which calculation is causing the problem.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi Mike,

please use your real name, thankyou.

actual version of RB is 6.03 and for Advantage 6.11.
Do you have that behaviour with every report?
Are you using RAP?
Any events in use that could cause the delay?

regards,
Chris Ueberall;

rbuser

The first thing to test is to make sure you are getting the data at runtime.
Hook the datasource that the datapipeline is conected to, to a TDBGrid on
the form. This should show the records at runtime.

It does.

Is there anything else
that you are doing in code that could affect the query? Most likely the
delay is a problem with on e of the calcualtions you have for your report?
Can you provide more information on what the event handlers for this report
are calculating? Try commenting some of them out, incrementally, in order to
isolate which calculation is causing the problem.

I'm not doing any calculations at all. I'm just trying to display the
contents of one table. I must be doing something really dumb because my
report is VERY simple.

Any other ideas?

Thanks!

rbuser

please use your real name, thankyou.

I noticed I had my new reader set to an old email address, is this what you
mean by my real name?

actual version of RB is 6.03 and for Advantage 6.11.
Do you have that behaviour with every report?

I can't go to Adv 6.11 because of a large client on 5.7. I have MANY
reports that run with complex SQL statements and JIT pipelines and they all
work great. This is the only simple report I have (it's in a separate
application from the other reports). That's why I think the problem must be
something really basic.

Are you using RAP?
Any events in use that could cause the delay?

I'm not using RAP and am not using any events.

Thanks!

Mike Allred

digitalmetaphors

It may be possible that the report and data controls are connected to a
different datapipeline in your project? The report could be opening the
datapipeline that it is connected to, but the data controls in the report
are connected to another datapipeline which is connected to a closed query?

If not, then create a new empty project and try to show just this one query
in a report at runtime:

ADSQuery -> Datasource -> DBPipeline -> Report
|
V
DBGrid

You could try installing RB 6.03 just to see if it helps, but I would guess
that it won't. Check all conections as shown. Feel free to send us an
example. We are running ADS 6.11a. Send a minimal example project with the
ADS table to support@digital-metaphors.com

Cheers,

Jim Bennett
Digital Metaphors