How to show signature image of an SSRS Report based on workflow userid approval - d365fo x++

(1) Share

Report

Posted on by D365FO DEV

400

Hello everyone,

i have a requirement that i have 2 png pictures, one with CEO signature, and other with CFO signature.

I have added them in the images section in the report.

the report is an extension of Purchase order confirmation report.

Now i want based on workflow approval condition, if the user has a job title "CEO" to show on the report the ceo signature.

if the approval userid has CFO as job title to show CFO signature.

anyone can provide me with full steps to accomplish this?

thank you

All responses (12)

Answers (0)

Raj Borad 491 on at

Like (0)

Report

How to show signature image of an SSRS Report based on workflow userid approval - d365fo x++

Hi Martin,

I tried it in the AX 2012 and it worked to get the approval date and approver name from the WorkflowTrackingStatusTable.
Martin Dráb 230,371 Most Valuable Professional on at

Like (0)

Report

How to show signature image of an SSRS Report based on workflow userid approval - d365fo x++

rajborad, your code won't compile at all and the logic is wrong. You apparently wanted to use a while select statement to iterate all PO-related records in WorkflowStatusTrackingTable (and than check Document field), but it would be very inefficient even if it worked. Instead, you should use ContextTableId and ContextRecId fields.
Raj Borad 491 on at

Like (0)

Report

How to show signature image of an SSRS Report based on workflow userid approval - d365fo x++

Hi,

Here is the reference of getting the name of purchase order workflow approval name.

select Workflowstatustrackingtable wstt
where wstt.TrackingStatus == WorkflowTrackingStatus::Completed
&& wstt.DocumentType == 'Purchase orders'
&& (this.DocumentState == VersioningDocumentState::Approved
|| this.DocumentState == VersioningDocumentState::Confirmed
|| this.DocumentState == VersioningDocumentState::Finalized);

{

if(strScan(wstt.Document,this.PurchId,1,255) != 0)
{
approvalDate = DateTimeUtil::date(wstt.modifiedDateTime);
}

}

I used above code in display method to show the workflow approval details in the form.

Thank you,

Raj D Borad
Suggested answer

Martin Dráb 230,371 Most Valuable Professional on at

Like (0)

Report

How to show signature image of an SSRS Report based on workflow userid approval - d365fo x++

Great, when you've identified your problem, we can finally get into solutions. The first step is using a search engine to see if the answer doesn't already exists - and it does. For example, look at Getting Workflow Approvers In Dynamics AX.
D365FO DEV 400 on at

Like (0)

Report

How to show signature image of an SSRS Report based on workflow userid approval - d365fo x++

my problem is im not able to retreive the userid from the workflow approval , so that i can later retreive the job position behind this userid.
Martin Dráb 230,371 Most Valuable Professional on at

Like (0)

Report

How to show signature image of an SSRS Report based on workflow userid approval - d365fo x++

Now you seem to be saying that you're struggling already with getting the user ID. Please tell us more about this particular problem. You're talking about a PO confirmation, therefore you already have the PO on-hand. Is the problem that you don't know how to get the workflow history for the PO?
D365FO DEV 400 on at

Like (0)

Report

How to show signature image of an SSRS Report based on workflow userid approval - d365fo x++

i alrady decomposed my question, first i need to retreive the userid in workflow details, then the job position behid this "person" of the userid.
Martin Dráb 230,371 Most Valuable Professional on at

Like (0)

Report

How to show signature image of an SSRS Report based on workflow userid approval - d365fo x++

As you see, you are unable to make any progress if you want to do everything at once. You need to decompose the requirement to smaller pieces and implement them one by one. If you know at least something about X++ programming (e.g. to find records and use the "if" statement), you should be able to implement some of them, and then you can ask here about the things you don't know.
D365FO DEV 400 on at

Like (0)

Report

How to show signature image of an SSRS Report based on workflow userid approval - d365fo x++

i want to get the userid position that accepted the workflow. and if the position is CEO, to print CEO signature, if the position is CFO, to print CFO signature. thats it.
Martin Dráb 230,371 Most Valuable Professional on at

Like (1)

Report

How to show signature image of an SSRS Report based on workflow userid approval - d365fo x++

Are you saying that you don't know how to get user's position and that's the information you want to get from us?