updated member listing for ReportUtilities. - D-Tools Forum

aantrim · 08-03-2009, 08:02 PM

I was wondering if there is an updated member listing for all of the helpers in Report Utilities. I am designing a new service order and would like to include the resource's email address. I have tried to use some logical naming formats to see if I could get lucky but I haven't yet. The resources are tied to ServiceOrder.GetResources. Don't know about the email though. Any thoughts or advice?

nkarthick · 08-04-2009, 10:29 AM

You can get the email list of service order by iterating through the service order resources which is demonstrated in the below sample script.

Sample Script Code –

Code:

Imports  DTools.SystemIntegrator.Common.Scheduling

Sub ActiveReport_ReportStart
	If ReportUtilities.ServiceOrder IsNot Nothing  AndAlso ReportUtilities.ServiceOrder.Resources IsNot Nothing Then
		Dim emails As String = String.Empty	
		'Iterate through Resource list of Service Order
		For each res As IResource  in ReportUtilities.ServiceOrder.Resources		
			'Get the email of the service order resource
			emails = emails + "  " + res.Email
		Next	
		emails = emails.Trim()
		'Assign the email list to the appropriate control of the custom report.
		ReportUtilities.SetTextBoxValue(rpt, "grpCompany", "txtEmail", emails)
	End If
End Sub

Hope it helps.

aantrim · 08-07-2009, 07:52 PM

When running the new service report an error comes up stating that IResource is not defined. How do I define this?

nkarthick · 08-08-2009, 04:44 AM

Make sure you have included the below line at the top of the script.

Imports DTools.SystemIntegrator.Common.Scheduling

Also i have updated the sample script code
by changing the line
from
Dim emails As String
to
Dim emails As String = String.Empty

make sure to include the changes in your script.

Hope it helps.

aantrim · 08-12-2009, 03:19 PM

That definitely helped, thank you very much. Another similar question. Are the resources in the resource manager (scheduling) linked to the Staff Types and Members in the Application settings? I am also trying to include the sales rep and his contact info onto the service order. I don't think this is possible but maybe you have some insight.

NareshN · 08-13-2009, 05:09 AM

The resources in Resource Manager (scheduling) and Staff Types are not linked now.