Answered by:
Workflow....trying to get my head around how to do particular workflow...

Question
-
Hi,
I have been asked to come up with a workflow that does the following...
1: Runs a saved advanced find - called Completions - DIO's (This is a list of trainees that have completed training within a specific date range)
2: Print a Certificate for the Trainees (Currently the list from the Advanced Find is exported to Excel and then Mail-Merged to a Word Template (Outside of CRM) where the correct fields are selected and then printed accordingly as well as Labels with Name and Address details etc) NOTE: I would like to see this done within CRM rather than have a separate process etc.
3: Certificate is Awarded to the Trainee within the CRM system with default fields pre populated based on their qualification gained.
I am just trying to get my head around how a workflow would be created to do these tasks as 1 On Demand Workflow, which may also run Child Workflows, and logically it certainly seems that this would be achievable, it is the working out of how this will be best done..hope that makes sense ;-)
Cheers and regards RosscoThursday, October 7, 2010 10:27 PM
Answers
-
Hello, Rossco.
To create this functionality you can use following steps:
1. Create report which will generate certificate based on current trainee.
2. Publish this report in CRM with Publish for external use option.
3. Create custom workflow action which will render this report using Reporting Services WebService, export it to Excel, pdf or word and then you can choose what to do - send it using email, save to some shared folder or some other store.
As a sample you can check my article - http://a33ik.blogspot.com/2009/08/custom-workflow-action-which-renders.html
Microsoft CRM Freelancer
My blog (english)
Мой блог (русскоязычный)- Proposed as answer by Jeff Loucks Friday, October 8, 2010 12:45 AM
- Marked as answer by Donna EdwardsMVP Thursday, October 14, 2010 2:16 PM
Thursday, October 7, 2010 10:38 PMModerator
All replies
-
Hello, Rossco.
To create this functionality you can use following steps:
1. Create report which will generate certificate based on current trainee.
2. Publish this report in CRM with Publish for external use option.
3. Create custom workflow action which will render this report using Reporting Services WebService, export it to Excel, pdf or word and then you can choose what to do - send it using email, save to some shared folder or some other store.
As a sample you can check my article - http://a33ik.blogspot.com/2009/08/custom-workflow-action-which-renders.html
Microsoft CRM Freelancer
My blog (english)
Мой блог (русскоязычный)- Proposed as answer by Jeff Loucks Friday, October 8, 2010 12:45 AM
- Marked as answer by Donna EdwardsMVP Thursday, October 14, 2010 2:16 PM
Thursday, October 7, 2010 10:38 PMModerator -
Hello, Rossco.
To create this functionality you can use following steps:
1. Create report which will generate certificate based on current trainee.
2. Publish this report in CRM with Publish for external use option.
3. Create custom workflow action which will render this report using Reporting Services WebService, export it to Excel, pdf or word and then you can choose what to do - send it using email, save to some shared folder or some other store.
As a sample you can check my article - http://a33ik.blogspot.com/2009/08/custom-workflow-action-which-renders.html
Microsoft CRM Freelancer
My blog (english)
Мой блог (русскоязычный)Hi Andriy,
thanks for this....but I may need some more help on this as my knowledge of the reports is limited....does the reporting effectively work like an advanced find?
Cheers and regards Rossco- Edited by GrenadaV Sunday, October 10, 2010 9:58 PM typo
Sunday, October 10, 2010 9:48 PM -
Hi, Rossco.
Reporting Services are different and it is not similar to Advanced find.
Microsoft CRM Freelancer
My blog (english)
Мой блог (русскоязычный)Monday, October 11, 2010 6:16 AMModerator