To simplify what I'm trying to do, the four output records that are showing in my List Report (see below), should really show up as one record with all values showing in one record (see last, single, record). I've tried aggregating, grouping, etc. but can't seem to accomplish what I want. In standard programming or using Access, this would be easy to do. Would appreciate any thoughts/ideas. I've only been working with Report Studion for a couple of months.
ID |Last |First|NCLB|Program |Yrs in Prog|Poverty|Grad Code
123|SMITH|JOE |Y | |3 | |
123|SMITH|JOE | |5676 | | |
123|SMITH|JOE | | | |Y |
123|SMITH|JOE | | | | |0385
123|SMITH|JOE |Y |5676 |3 |Y |0385
Thanks, Sheldon
Hi,
I'd probably use the approach of grouping on ID, then using calculations using the maximum() function for each of the other items.
Regards,
MF.
Thanks MF. In my example, ID, Last & First go together i.e. 123 will only go with Joe Smith.
Also, fields like NCLB, Program, Poverty and Grad Code are all determined from the same (Program Id) field which consists of a numerical code that could apply to many areas like Program and Poverty. Don't know if that information changes your suggestion(s).
Sheldon
Nope - no change. Did you manage to get it working?
MF.
I spent a fair amount of time but still have not been able to get it working.
With help from a more seasoned Cognos professional, I was able to get this working using Maximum (as you suggested MF), thanks.