Re: Report Designer: [Activity.ContactPhoneNumber] - Doesn't return customers' phone numbers

Method_Greg — Fri, 12 Sep 2014 13:50:39 GMT

Hello Ivana,

I had a recent post asking the same question. Take a look at this post and let me know if this helps. In summary, A work order/activity is actually set by the Entity and not the Contact. Hence, ContactPhoneNumber won't have any information to display and appears blank. You need to add the entities phone number to the activity table and use this field on the report.

Greg

Report Designer: [Activity.ContactPhoneNumber] - Doesn't return customers' phone numbers

Ivana — Fri, 12 Sep 2014 07:32:01 GMT

Hello,

I have a "route list" report set up in the Report Designer; the tables used are: Activity; ActivityJobItems; Company.

I believe we buildt/redefined this report based off an template that was already available in the Report Designer tool.

We need to add "Customer Phone" (Contact Phone) in to this report, so I added the "[Activity.ContactPhoneNumber]" under the Detail Band. Unfortunately the report doesn't return any data at all - the attribute "[Activity.ContactPhoneNumber]" in the final report is blank for all customers.

Kindly advise what needs to be done in order to get the Contact/ Customer Phone Number in our report.

Thank you, Ivana

Method:Classic General Q&A

Re: Report Designer: [Activity.ContactPhoneNumber]﻿ - Doesn't return customers' phone numbers

Report Designer: [Activity.ContactPhoneNumber]﻿ - Doesn't return customers' phone numbers

Re: Report Designer: [Activity.ContactPhoneNumber] - Doesn't return customers' phone numbers

Report Designer: [Activity.ContactPhoneNumber] - Doesn't return customers' phone numbers