Report with Approval and Variables for Requested Items.

[Ashish Gupta6]

I want to create a Report with Approval and Variables for Requested Items. 

#1 Approvals details should be some fields from <sysapproval_approver> table.

#2 Requested Item details <sc_req_item> and DBll the Variables details including the Question and Value provided by User.

I tried creatinDBdb views - but both the details are not available together.  

[Naveen4]

Hi,  create a report on the SYSAPPROVAL_Approver table and by using  conditioner builder u can pull out hte filelds what ever you want.

for fileds on the task table you can use dotwalk as well.

here attaching the sample report screen.

 using dotwalking:

Thanks,Naveen

[Ashutosh Munot1]

HI,

Which tables you used for that DB view?

Thanks,
Ashutosh

[AlexS_]

Ashish -Did you ever find a solution for this? We already tried the suggestion Naveen had but you can't pull in the variables from the RITM into the report even though you can dot walk to them from the Available window and they appear "Selected"

[VShine]

@Ashish Gupta or @AlexS  did you able to find solution for this?