[sqr-users] How to compensate for poor table design?

["McCown, Larry" <larry.mccown@ngc.com>]

Greetings all,
I have built a report that appears to me to be poor table design, but I am 
looking for recommendations how to overcome this issue.
I need to print out the QuestionID and the Answerrating for a ticket.  But 
being that that each Answerrating is on a different line I receive the ticket 
number 4 times.  I am using the on-break level and then I don't see the 
ticketnumber more than once but I do get  blank lines between each questionID.
Hope this makes sense.
Thanks so much for you help.
 
 
Table
Ticketnumber    Answerrating    QuestionID
W361062                1                            1                
W361062                1                            2
W361062               2                            3
W361062                                            4
 
 
Results:
W361062
 
1  1
 
2  1
 
3  2
 
4
 
 
Maximo 4.0.3 
SQL Server 7.0
 
Larry  *
Larry McCown
Northrop Grumman
Western Region Facilities
One Hornet Way WG00/W5
El Segundo, Ca. 90245
Phone (310)628-3939
Fax      (310)332-3149
 <mailto:Larry_McCown@NorthropGrumman.com> 
Larry.McCown@NGC.com <mailto:Larry.McCown@NGC.com> 
Words kill, words give life; they're either poison or fruit - you choose.
Instead of complaining about the thorns on roses, be thankful for the roses 
among the thorns.
 
 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users