Dynamics Community Forum Thread Details

Altering the source expression on a request page field

Hey all,

I'm working on a custom report has a request page.

On the request page I enter Order No. the next field below it on the request page is Contact No.

When I enter the Order No. the contact number defaults. How can I control that default?

For example: Order No. 3 has the location-contact: Rob contact ID 01 and the owner-contact: Zach contact ID 02.

I run the report and enter in order 3 on the request page, the field below it auto populates Zach contact ID 02 the owner-contact. My goal is to enter the order number on the first field and have the location-contact Rob show up.

The report is built on a single dataItem Contact. In order to distinguish owner-contact from location-contact I'll need to use the Customer table.

Looking at the properties of the request page field that i'd like to auto populate:

SourceExpre = VAR_ContactFilter
TableRelation: Contact.No.

Could I join Contact (the reports dataitem) to Customer on the tableRelation property of a Request Page?

What are other options for automating a fields value?

I'd be happy to explain further. Thanks so much.