I am working off of an application for university where students apply online and then the information is sent to a datatel database on sql server 2008. The problem I am getting is when I am trying to display some of the information is that there are fields like honors that the applicant can enter multiple fields into. When I am trying to display this information cyrstal creates a new report every time there is a new honors field.

Does anyone know of a way to get the field to display on one section. The name of the field is {Datatel_honorExtensionBase.Datatel_name}, and I can not see where it is assigning a different name for each instance of the honors. It attaches the honors to an application id, then distinguishes each field by a key value.

Sounds very confusing, I know, but it has been driving my mad for the past two days trying to see how to get this field to display all at once instead of creating a new instance every time.
Thanks
Kevin

I am not sure if I understand using the shared variable.

I am a semi newbie to this so I am trying to remember stuff I haven't done in a couple of years.

Basically I need to figure out how to loop through the record and pull out the information to display per person.

So if one person only has one honor, but the next has four, I need to get it to print with the person and not produce a second or third report to display the next honor.

Thanks

As DBlank mention, if you are grouping on the application id(let's say).

create a different shared variable for each field.  Increment the field as appropriate.  So while you might increment all the variables in 1 formula (and reset them in 1) you would have multiple lines for the increment, and multiple formulas for display (one per variable).

sorry misunderstood, thought that there were dupes between the different headings.  So, just looking at extracurricular, there are dupes, one would think that the most likely reason for this is that in a join, there is a result of 2 records...so how to get around it?