Is this possible?

rbuser

RBuilder 7.03 - Delphi 7

Hi!

I have a TTable with, for example, 100 customers.
I have a report with its own SQL sentence, saved as a RTM file. This report
prints only some customers (not all), for example, those older than 40 year
old, because it has its own sql sentence.

Is if filter the TTable with other condition...
Is it possible to make the report to use the same filter I assigned to the
table?

for example:
I want to show a message dialog that ask the user for printing using the
saved report sql or the current filter of the Table.

Any ideas?

nicocizik

Hi Santy,

If you have a report with its own SQL statement, I assume you are using DADE
and have created a data module to view your data. It could be possible to
disconnect this datapipeline at runtime in one of the template events such
as the OnLoadEnd event depending on what your user wants to do. Then you
could connect another pipeline that is connected to your filtered TTable.
It is however not recommended that you use filtered datasets with
ReportBuilder as it slows the performance significantly. Would it be
possible to create another data module in DADE to give the same data as the
TTable on your form?

--