Rolling data up into one line

[ClaireClaxton]

Hello all

I am very new to Business Objects and have a little "issue" that I need some advise on. Please excuse me if I sound like I'm talking to a simpleton but it's the only way that I can get my head around the problem!!!!

When my data comes across and is uploaded into the universe that I interrogate, it comes in as one line per product.

Therefore, I could have several lines for one customer.

What I need to do it to show each customer, their invoice number but then roll all of the products up into one line which is where I am coming unstuck.

I have tried making it into a crosstab table but it is still returning one line per product.

Is there any way that this can be done? If so, what do I need to do?

Thanking you in advance

Claire Claxton

 

[Auger282]

sounds like you need some kind of enterprise resource planning software (ERP)

in a simple world you would have to come up with some kind of nasty script that could do what you are talking about...

..in coding terms.. I'm thinking you would build an array of unique objects.. then when it hits an object that is already in the array it could just kick up the counter 1...


is this in an access database?.. I'm guessing someone is scanning this data in.... It really depends on if its in a text only form or how its coming into or out of your system.