Summarize columns in Reports and Dat aPages
Hi,
I have craeted a report "R" for the class "X" that makes a sum of two properties using the function SUM. This sum is expressed in a nuw column called "WorkSum".
I have defined also a Data Page "DP" of type List and Object Type "X" based on the report "R". I have used also a Data Transform "DT" for mapping the response of the report "R" and the class "X. In the "DT" definition I'm not able to get the column "WorkSum".
Any suggestion?
Thanks,
V.
***Updated by Moderator: Marissa. Removed user added #helpme group tag. Apologies for confusion, shouldn't have been an end-user option; updated categories***
Hi,
I was wondering how to read the "WorkSum" that doens't belong to the class X (it is a calculated column). Is it necessary to use a DT?
Hi,
I have found teh solution using the DP ibn this way:
D_WorkTime[Parameters...].pxResults(1).pySummaryValue(1)
Thanks,
V.
I am little confused. You are returning results of class X from your report R and your Data Page is also a list of type X. So why do you need a data transform?
Also, did you check and see if the query on how the property "WorkSum" is being retrieve and how it is being set on the clipboard?
-Rajiv