Solved

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

Posted on 2011-10-01
1
220 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
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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 article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video discusses moving either the default database or any database to a new volume.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

744 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now