?
Solved

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

Posted on 2011-10-01
1
Medium Priority
?
276 Views
Last Modified: 2012-06-27
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
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
rajivkapoorONidealsdotcodotin earned 0 total points
ID: 36992330
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question