Thanks YGG. It seems like I only could get the Comments to show. The result is that Comment and Rating shows duplicates of the Comment Text (i.e, the service was great!, good!, Bad, etc)
SubID Rating Comment
100 Good Good
200 Okay Okay
300 Horrible Horrible
This is what i have in the details section:
@Comment Formula:
whileprintingrecords;
stringvar comment;
if isnull({fieldcommentrating})then comment:=comment else comment := {fieldcommentrating}
@Rating Formula:
whileprintingrecords;
stringvar rating;
if isnull({fieldcommentrating})then rating:=rating else rating := {fieldcommentrating}
As a note:
fieldcommentrating contains data such as: 9, good, 8 OK, 1, bad etc
fieldname contains data such as : "Rating" and "Comment"
Then I grouped by the SUBID.
The following formulas were created to put in Group Footer Section (along with SubID field):
@Rating2
whileprintingrecords;
stringvar rating;
@Comment2
whileprintingrecords;
stringvar comment;
Edited by bigwang916 - 24 May 2012 at 5:59am