Eclipse Community Forums: BIRT » Getting more then one result in a single result field

Home » Archived » BIRT » Getting more then one result in a single result field(Getting more then one result in a single result field)

Show: Today's Messages :: Show Polls :: Message Navigator

Getting more then one result in a single result field [message #1573407]

Mon, 19 January 2015 18:31

Jacob Riley

Messages: 5
Registered: January 2015

Junior Member

I have a semi-complicated report with a number of different data sources, and for the most part the report it working correctly, with one maddening exception. I have one table, with two results from the same data set. Both of the results are computed columns, simple concatenations of output columns, and one of them work correctly, but the other returns all results each time it displays.

An example of what it's doing:

If the results returned from the Db are:
Names: Smith, James E and Smith, Jane F
Address: 1234 Main Street, Erehwon AK 99501

The results displayed on the report like this:

Name: Smith, James ESmith, Jane F
Address: 1234 Main Street,
Erehwon AK 99501

Name: Smith, James ESmith, Jane F
Address: 1234 Main Street,
Erehwon AK 99501

As far as I can tell I have the address and the name field coded the same, but they behave differently. Any ideas why the name field is might be displaying all the results?

Report message to a moderator