Report only pulling from one sheet, when the filter is applied.

vjschmid

I've created a report pulling from two sheets. With no filter on, the report pulls from both sheets fine. Once I put the filter on, it's only pulling from one sheet. Advice on what I'm doing wrong?

Genevieve P.

Hi @vjschmid

It sounds like you might be filtering based on a column that only exists on one of the two sheets. Can you check the Column Name that you're using for the filter, and then check to make sure that exact same name is being used on each sheet? See: Select Columns to Display for Report Builder

If the name is identical, then it may be that the value you're using to filter by is only on one sheet. For example, if one sheet uses "Complete" and the other uses "Completed" with a D, then if you filter by "Completed" with the D you will only see one sheet's data. Does that make sense?

If this hasn't helped, it would be useful to see two screen captures of the Report: one with both sheets showing and one with the filter applied (identifying what the filter is).

Thanks!

Genevieve