Autosearch Lookup
I am trying to implement the new Autosearch field lookup feature in RB11
Professional but I am having trouble getting it to work. I am looking at
this from the point of view of an end user application so I need a
solution that doesn't involve writing code (and our users don't have RAP).
As a test I have created a new report, configured 2 dataviews (1 for the
report and 1 for the lookup), created a parameter on the report and set
the LookupSettings to point to the lookup dataview. I have then created an
autosearch parameter on the report dataview and linked it to the report
parameter, however I don't get a lookup list on the autosearch screen,
just a normal edit box.
Am I overlooking something or have I misunderstood what to expect?
--- posted by geoForum on http://delphi.newswhat.com
Professional but I am having trouble getting it to work. I am looking at
this from the point of view of an end user application so I need a
solution that doesn't involve writing code (and our users don't have RAP).
As a test I have created a new report, configured 2 dataviews (1 for the
report and 1 for the lookup), created a parameter on the report and set
the LookupSettings to point to the lookup dataview. I have then created an
autosearch parameter on the report dataview and linked it to the report
parameter, however I don't get a lookup list on the autosearch screen,
just a normal edit box.
Am I overlooking something or have I misunderstood what to expect?
--- posted by geoForum on http://delphi.newswhat.com
This discussion has been closed.
Comments
I just tried a simple example here using the DBDemos data and it worked.
- Create New report
- Access Data workspace, create query on customer.company
- Access Design workspace, add a Parameter
- Set Parameter.AutoSearchSettings.Enabled to True
- Configure Parameter.LookupSettings: set DataPipeline to Customer. Set
ValueField to Company.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com