I have a problem which i am not able to resolve in report studio
i need to group all the items in the list based on the logic below
"roll up" lines that have the same code and hcp into one display line
NOTE: Only Roll up if both Code and HCP are present and are the same. If either field is missing , it should not roll up
CodeÃ, Ã, HCPÃ, Ã, Units Charges Ã, FeeÃ, Ã, Ã, Ã, Ã, Type
0291Ã, E0165Ã, Ã, 1 $18.96 $18.96 DME
0291Ã, E0165Ã, Ã, 2Ã, Ã, Ã, Ã, Ã, $25.23Ã, Ã, Ã, $25.23Ã, Ã, Ã, DME
0291Ã, E0167Ã, Ã, 1 $12.26 $12.26 DME
0233Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, 1Ã, Ã, Ã, Ã, $11.11Ã, Ã, Ã, $11.11Ã, Ã, Ã, SME
0233Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, 2Ã, Ã, Ã, Ã, Ã, $10.11Ã, Ã, Ã, $10.11Ã, Ã, Ã, SME
so in this table as both code and hcp are same in row 1 and2 we need to add them and show them as one
but not in the case of last two as hcp is not populated,
so can any one give me a solution to this problem
thanks
vkRaj
Hi,
Do it this way
I have taken 3 dataitems which correspond to your requirements : no , code and price
Take a tabular set and use two filter conditions for eg : no and code not = null
and another condition no or code = null
for the first condition change the aggregation property of price as Total
So now you have the duplicate entries grouped and non duplicate ones with nulls non grouped
HTH
I am also attaching an xml with this just to give an idea
the model has 3 query items as no , code and price ....
Keep us informed ;D ::)
Or you can just select only the columns u r listing, apply the aggregation functions on the data items properly and just drag the columns in the list.
When i see ur problem i feel, that your query has some more columns than showed in the example but, not dragged on to the list. Check that out too..
Srik