Finance | Project Operations, Human Resources, ...

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

(1) Share

Report

Posted on by D365FO DEV

406

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

I have the same question (0)

All responses (12)

Answers (0)

Martin Dráb 237,965 Most Valuable Professional on at

Like (1)

Report

It's not clear what you need from us, but if you have no idea how to show an image, look at how the report deals with the company logo.

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report

Hi Martin.

My question is clear. i know how to show image on a report. but issue is i want the source code of the method that retreives the job position of the userid that is responsible of acception a workflow.

to be more clear, for the purchase order report. lets say the userid "X" accepted the workflow, and this "X" is an employee and has a job poisition as "CEO". i already have a signature image of the CEO and want to show it on the report if "X" is the approval. my issue is how to know if "x" is the approval or not.

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (1)

Report

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?

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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?

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Raj Borad 1,428 on at

Like (0)

Report

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

Was this reply helpful? Yes No