If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Grouping a List in Reportnet

Started by vkrajudatla, 09 Apr 2006 11:25:13 AM

Previous topic - Next topic

vkrajudatla

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

zenith

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 ::)






BIsrik

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