Passing search fields to rtm report

rbuser

Hi,
I've created a report layout and saved it to a RTM file (OrderJournal.RTM).
I want use several AutoSearch fields but without the AutoSearchDialog,
because I want control the user input. So I wish :

a) Create a user dialog form where the end user can define parameters for
the report (like From Date to Date, From Customer to Customer, From Supplier
to Supplier and so on).

b) I don't want use the AutoSearchDialog but instead I want to pass the
parameters directly to the RTM after the user press the OK button on my
dialog form to create the preview of the report.

I've ridden something about but I'm a bit confused.

It'is possible?
Many thanks in advance
Robert

nicocizik

Hi Robert,

Take a look at the TdaSqlBuilder object included in RB 9 or higher. This
object allows you to manually add search criteria to your DataViews in DADE
very easily. You could for instance, retrieve the search parameter from
your user using your own dialog, then insert it into the query in DADE after
the template is loaded in order to achive what you need. Take a look at the
TdaSqlBuilder topic in the RBuilder help for more information and code
examples.

--
Regards,

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

rbuser

Many thanks.

TdaSQLBuilder? I've found it on the help. It's a component? I can't see it
on my RB9 palette.
Robert

nicocizik

Hi Robert,

The TdaSQLBuilder object is not a visual component in ReportBuilder. It
needs to be created and used at runtime in code.

--
Regards,

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