need help getting BO to report multiple data points per record

[Coffin]

While I'm new to the forum I've been playing with BOXI for about a year now. I'm stuck on a queery, trying to pull about 50,000 records with 12 data points per record. Everything so far works fine. The problem is for some of the records on one point there are multiple entries that I need to grab and list as Eng-1, Eng-2, Eng-3, Eng-4. There are only 4 Engineers possible per record.

Does anyone have any tips for this without diving head first into SQL (which will set me back a couple weeks).

Thanks.

 

[blom0344]

I have no idea what you mean by data points and without knowledge of the database and universe structure it is very hard to give any advice. However, posting the SQL may give us an idea what you are attempting to do. There is plenty of SQL expertise around to give meaningfull input.

Ties Blom