Hi All,
I am very new to SSRS. We have a requirement to send WorkOrder(WO) alert mails to user based on their department. I have provided sample table details below(Please check the attachment if it is not clear).
Table 1: (Work Order Details)
WODepartment Due Date
11IT 20-Oct
22Procurement21-Oct
33GHD 22-Oct
44Networking 23-Oct
55Procurement24-Oct
66IT 25-Oct
77Networking 26-Oct
88GHD 27-Oct
99Finance28-Oct
Table 2: (Email ID details)
Department Mail ID
IT ab@gmail.com
Networking cd@gmail.com
GHD ef@gmail.com
Procurement gh@gmail.com
Finance ij@gmail.com
Daily I have to send Work order alert mails automatically to users. For example, 11 and 66 details to ab@gmail.com, 44 and 77 details to cd@gmail.com, 33 and 88 details to ef@gmail.com.
Could you please tell whether it is possible in SSRS(DDS)? If it is possible, please give your valuable suggestions.