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

Flattening Data In A List Report

Started by Sheldon, 06 Apr 2010 12:38:59 PM

Previous topic - Next topic

Sheldon

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

MFGF

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.
Meep!

Sheldon

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

MFGF

Nope - no change.  Did you manage to get it working?

MF.
Meep!

Sheldon

I spent a fair amount of time but still have not been able to get it working.

Sheldon

With help from a more seasoned Cognos professional, I was able to get this working using Maximum (as you suggested MF), thanks.