I am trying to extract approval information for journals including amounts. Challenge is how to extract more that one approver in one row instead of multiple rows
Answer
How extract multiple document approvers as one row per document
Best answer by WillH
In the Generic Inquiry screen ,I don’t think there’s a string concatenate aggregate function, so I don’t think it can be achieved there.
Reference:
Per the response there, you can achieve this if you’re willing to create a SQL view and extend a DAC as a customization.
But you can achieve this kind of thing through careful use of groupings & variables in a Report Designer report if you’re willing to go that route.
+4
Challenge is if there are multiple approvers, they still are in different rows, i want a pivot behavior where the approvers are in columns in same row
+3
In the Generic Inquiry screen ,I don’t think there’s a string concatenate aggregate function, so I don’t think it can be achieved there.
Reference:
Per the response there, you can achieve this if you’re willing to create a SQL view and extend a DAC as a customization.
But you can achieve this kind of thing through careful use of groupings & variables in a Report Designer report if you’re willing to go that route.
~Will H (MYOB)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.