I am running into a scenario where my report in the Service is not acting the same as my report in desktop.
I have two tables where I am using one as a filter for the other. The second table will not have the exact same records as the first table, so I would expect the second table to be filtered to nothing if I click on a record that it does not have.
Please forgive the images, just blocking certain information from view. Let me know if it isn't clear.
This is what happens in Desktop. The bottom table will display nothing.
This is what is happening in the Server. The bottom table is frozen to whatever it was previously filtered to.