[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

How to fix a BI reporting issue in SPD 2010 Workflow with Wait for field change?

In a SharePoint Designer workflow designed, there is a connection and back end sql stored procedure call for a report after Wait for field change activity. The report completely fails if it is called after this Pause activity. Another similar workflow designed by someone else works perfectly fine in the same environment. What could be the reason?
In my requirement the report is supposed to be fired if an assignee of a task changes an InfoPath form field status, so it has to be generated after the field has changed and hence the back end call is to be made after the pause. But after hitting the pause the report fails. How to fix this issue?
The report is ultimately used along with Performance Point server.
0
rajivkapoorONidealsdotcodotin
Asked:
rajivkapoorONidealsdotcodotin
1 Solution
 
rajivkapoorONidealsdotcodotinAuthor Commented:
Keep the status of the task change in a variable and compare its value for a change in side a while loop and then call connection for BI
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now