Previously if you wished to construct a report for which you selected the records for example for one Engineer then previously you had to type in the engineers name in exactly the same way as it appears in Access Rights. It is now possible to link in different tables and use these as part of the report selection process thereby eliminating the potential for error.

Data Pipelines

Create the data pipelines with the appropriate selection as usual, then create another data pipeline which contains the data you wish to use as part of the selection process. In the case below we have selected the snames table, field name and the selection criteria is ENG = 'Y' so that snames only shows Engineers

Design Report

Design the Report as previously using the jobsheet data. Now select the Parameter Editor from the Generation Properties editor on the left, this will open the Parameter Editor.

Using the Parameter Editor, add button, add a new Parameter

In the LookUpSettings set the data Pipeline to SNAMES and the NameField to be NAME and the ValueField also to NAME.

Replace the UserName Parameter1 with a meaningful name for this context, i.e. EngineerName.

In the AutoSearchSettings set the DataPipeline to be JOBSHEET and the FieldAlias to be ENGINEER

Return to the Data Tab and the Jobsheet Pipeline and in Query Designer, the Search option

Against the search option JOBSHEET.ENGINEER, select the Parameter Option and link this to the Engineer Name Parameter which we have just created.

When the Report is run the Search Option for Engineer should now appear as below and display a list of Engineers from which to pick.

Back to Top

Personal Computer Data Services
135a Belgrave Drive, Boothferry Road, Hull, HU4 6DP
Enquiries/Support Phone: 01482 607350 - Fax: 01482 326393
Email: sales@pcdata.co.uk