Problems with certain roles not showing data

Hi,

I have a problem with certain roles... I have 64 roles assigned of which 16 are not working well, all within the same report. I asign the role with the proper column name which I use as a filter, when I click on the button next to the role assignation "See role as" which lets me see the report from a specific role it shows no data from any table... I don't understand why while the other roles can be seen just fine and have data.

I noticed this when I published my report online, I gave permissions in the RSL security section and again, everything can be seen fine except *those* roles, I don't get what I'm doing differently from the other 50+ roles that show the data just fine.

Of course the filters work just fine in desktop and show everything, it stops displaying after I assign the role and try to see it from that role. Any ideas what could be the problem?

Seeing the report as other roles:

1) I can see it in the filter

2) I can see the data

Seeing it with the problematic roles:

1) it doesn't even appear in the filter

2) no data shown

The roles are assigned exactly the same for both.

--------------------

UPDATE: the issue was that all the tables are connected through the filter column but for these roles they didn't have data in one of the tables (which was okay) so I had to fill them with 0s to make it work.