Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Process stage linked t...

Process stage linked to Opportunity into SSRS report

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi guys,

Thanks again for all the help so far. I'm doing an SSRS report (using SQL, on prem 2015) for Opportunities and there is a requirement to pull the stage from the business process flow.

I've managed to pull a dataset for FilteredProcessStage (Processstage) which has a stagename field, so I did an expression of =lookup(fields!processid.Value, fields!processid.Value, fields!stagename.Value, "Processstage") but this just pulls the same stage (the first one), not the one related to the opportunity.

I'm missing something, but I can't see what! Any help greatly appreciateD!

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Process stage linked to Opportunity into SSRS report

Thanks ever so much!
Verified answer

a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: Process stage linked to Opportunity into SSRS report

Hello,

Try to use something like:

=lookup(fields!stageid.Value, fields!processstageid.Value, fields!stagename.Value, "Processstage")