Help with logic behind a report in SAP BOE BI Platform

[Former Member]

Hello, I'm not sure if I'm at the right place or not, but I'm using the SAP BusinessObjects (I'll provide some screenshots to better explain my issue)

Some background;

There are SO (service orders) received in the entire company and each SO has multiple tasks that are completed by different people and in different departments. So if you're displaying a report with all SOs without any filter you'd find one SO duplicated as many times as the unique tasks it has. Now to restrict my findings and do analysis on SOs that have just passed by or were completed by our department, I apply a filter on the table in my report that would display those SOs that contain the task name specified. My problem comes here: what I end up with is selected rows or in most cases one row that has that task with the SO as the primary indicator. But I don't want that, I'd like it to display all the rows and tasks related to the SO if the SO has that one task name included.

I tried simplifying it as much as possible I would appreciate any kind of help thanks in advance.

Please refer to the attachments. I added one screenshot and a sample of the data extracted

Also, cross posted here just in caseedw.jpgedw2.jpg

http://www.forumtopics.com/busobj/viewtopic.php?p=1054903#1054903