How to sum all rows in report definition
Hi guys,
Actually i have one requirement. we have cost , tax and total
Based up state cost ,tax and total we will calculate.
yearly wise we pull the report
Tx---COst(2000)----Tax(50)---Total(2500)---22nd july 2022
NY---Cost(1000)-----Tax(10)---Total(1500)---1st feb 2023
Tx---COst(2000)----Tax(50)---Total(2500)-----5th May 2023
TX---COst(2000)----Tax(50)---Total(2500)-----30 august 2023
Invoice Date I searched 1st jan 2023 to 30th august 2023
NY---Cost 1000------tax 10-----total-1500
Tx--- Cost--4000----Tax 100----total 5000
It's possiable to add all rows in single row based up on state by using report definition
Please help me out
Thanks in Advance
Accepted Solution
Updated: 10 May 2023 1:11 EDT
NCS Pte. Ltd
SG
Hi @kirti: Hope you are planning to use a table / grid in UI. Summary report cannot be added in table / grid because of hierarchical nature of results. Possible solutions to show the data to user.
- Give the report access to users directly
- Wrap the report with a Data page and use response data transform to transform the data from summary properties to other property and use the data page in your section. Please be cautious on your data volume
- Use connect SQL to get the data directly in property instead of transforming it later using data transform. This helps if the data set is huge
Thanks.
Bits in Glass
IN
1. Group based on State(All the records respective to those states will be grouped)-> So State will have sort ->1 after 1-1 group
2. Then apply sum on various fields
Saudi azm
SA
Hi Mate,
Step 1: Open your RD and in the "Columns" tab of the RD add a new column to the report and set the column source type to " Function"
Step 2: Now in the "Function" filed of the new column enter SUM (Without double quotes)
Step 3: Now in the "Arguments" filed of the new column enter the name of the column you want to sum ( if you want to sum multiple columns, separate their names with commas)
Step 4: Now save the RD and run
Hope this helps you....! Happy Learning
Thanks,
Sudheer
CI
IN
I grouped with state and i didn't sum value in summarize ,Only i have count ,countdisct,min,max and blank
CI
IN
Yeah i changed as decimal , But that values only come in Hierarchical Table , not in Normal Table
How to put the values in Normal table in Ui
Accepted Solution
Updated: 10 May 2023 1:11 EDT
NCS Pte. Ltd
SG
Hi @kirti: Hope you are planning to use a table / grid in UI. Summary report cannot be added in table / grid because of hierarchical nature of results. Possible solutions to show the data to user.
- Give the report access to users directly
- Wrap the report with a Data page and use response data transform to transform the data from summary properties to other property and use the data page in your section. Please be cautious on your data volume
- Use connect SQL to get the data directly in property instead of transforming it later using data transform. This helps if the data set is huge
Thanks.