AutoSearch on End-User reporting

rbuser

I am trying to make an End-User report solution with RB 6. Using the
samples included, I set the data dictionary to use some tables, but
cannot find a way to set its fields to AutoSearch = T. I updated the
dictionary tables by hand, but when I am designing/running a report, it
does not work. How can I do that? The idea is choose some tables and
make their relations using the data dictionary, then the user will
design its own reports using these "views". But we need to mark some
fields, so the data will be constrained to a small set. I want that the
user be able to supply values for these fields before running the
report.

Thanks.
Tailor

digitalmetaphors

You can create soem Custom Dataview Templates to do this. There is an
example in the RBuilder\Demos\EndUser directory. The autosearch criteria
have to be specified on the selected fields of the query dataview. The
other option is to have the user create the query and then choose one of the
select fields to be an autosearch field. You can also export a DADE
datamodule (.dtm) to the report explorer table. Then the user can load a
predefined datamodule which you have built for them. The end user can do
this from DADE by importing, or you can programatically load a .dtm into a
report:

procedure Foo;
var
lDataModule: TdaDataModule;
begin

lDataModule := daGetDataModule(ppReport1);
lDataModule.Template.FileName := 'C:\DataModules\Customer.dtm';
lDataModule.Template.LoadFromFile;

end;

Cheers,

Jim Bennett
Digital Metaphors

rbuser

I'm a little lost about the AutoSearch resource. We are using Allround's DOA
to access an Oracle database. I defined some queries that will act like a view,
and the end user will create it's reports based on this queries. I would like to

"mark" some fields that will be used as a filter, so the end user will supply
values
to they at report generation. I suppose that AutoSearch will do this
funcionality
automatically, but I can't get it to work. When using the design interface, I
can't
find where/how define autosearch fields. Even defining a DataDictionary and
setting
the table's relationship, I then inserted some fields definitions with the
autosearch
property adjusted, but how it will be used on the report designer?

Greetings,
Tailor Kaplon

digitalmetaphors

When creating a query go to the Search tab of the Query Designer and select
the field(s) on which you would like to filter your data which will bring
them into the bottom half of the dialog. Then simply check the AutoSearch
check box next to the field. At that point you can also provide default
search criteria, make the field mandatory (the user must enter search
criteria) and enable show all (all data will be shown by default.)

--
Cheers,

Alexander Kramnik
Digital Metaphors