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

Getting All Results On One Row

Started by Sheldon, 25 Jul 2012 02:52:50 PM

Previous topic - Next topic

Sheldon

I have seven fields - student id, last name, first name, date of English exam, score on English exam, date of math exam AND score on math exam.
For student 1, I would like:
1 Smith John 6/13/2012 80 6/15/2012 90

But what I'm seeing are two rows -->
1 Smith John 6/13/2012 80
                                            6/15/2012 90

Is there something I should be doing to get these seven fields into one row?

Thanks, Sheldon

Sheldon

Forgot to mention that this is a List Report.

Sheldon

ravimahazan84

Hi sheldon,

I tried the same but i am getting them in a single line wt i did i created a new data item and in that data item i concatanate like this
query obj1+query obj2+query obj3+........  so on and if you run this you will get the result in one row you can also put space b/w them for better view

hope this will help you

Sheldon

I was able to get unique values for each exam by using the following expression:
Maximum(If ([Test Name] Starts With ('English')) Then ([Test Date]) Else Null For [Student ID]).  So this gave me what I wanted until I saw that it didn't give me students who took the English test, got a failing score and had to take it again.  My expression only gave me their highest score and I needed to show all their test scores so I would appreciate any suggestions again as I've been working for hours on this.

Thanks, Sheldon