Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
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
?
284 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

618 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