Autosearch

rbuser

Hello
Using reportbuilder 7..03

Does anyone know how to stop multi autosearch datapipelines being visible to
the user?

If I set it to datapipline.false then the report ignores it. I want to use
the datapiplines but not made visible by user.

Only one pipeline need be visible for the user to enter search criteria of
which will be passed to other pipelines in the report.

Hope this makes sense.

Thank you

nardmoseley

The basic approach is to use the Query Designer to create Autosearch
criteria for the first query and then programmtically apply the search
criteria to the second query.

ReportBiulder 9 includes enhancements designed specifically to facilitate
this type of requirement. There is a TdaSQLBuilder class that can be used to
modify the TdaSQL object associated with a dataview and there is a new
Report.BeforeOpenDataPipelines event.

Here is an example of using the new Report.BeforeOpenDataPipeline event and
the new TdaSQLBuilder class to apply an autosearch field value entered by
the user to a second datapipeline.

var
lSQLBuilder: TdaSQLBuilder;
lAutoSearchField: TppAutoSearchField;
begin

lSQLBuilder := TdaSQLBuilder.Create(orders2);

lSQLBuilder.SearchCriteria.Clear;

lAutoSearchField := Report.AutoSearchFields[0];

if not(lAutoSearchField.ShowAllValues) then
lSQLBuilder.SearchCriteria.Add('orders', 'SaleDate', 'Between',
lAutoSearchField.SearchExpression);

lSQLBuilder.Free;

end;



--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com