Report - Not all Sheets Displaying

Zoe McInerney

Hi.  I've set up my first report to show tasks from multiple sheets with a date parameter.  Only one sheet of tasks is showing.  Wondering if there is an error of some sort in the sheets that are not displaying in the report.  Thank you.

 

Matt Hagler

Are the columns that you are pulling from the same on each sheet?  Also are all of the sheets selected in the "where" column in the report builder? 

J. Craig Williams

To add to Matt's likely suspects:

 

Columns of the same name may appear in different criteria (where? when? etc...) based on column type.

Or even in the same what? section for Dropdown vs Text/Number for example.

 

The other one is that the user only sees data from sheets they have sharing access to.

 

Craig

 

Zoe McInerney

THANK YOU. I'll try your tips.

 

mdcatlett

Similar problem here - trying to pull a report from two similar sheets, both based on the basic Project sheet. 

I'm trying to pull tasks for one assigned resource across these two sheets, where the status is anything other than 100%, between certain Start and End dates. 

The report is only drawing from one of the sheets in the scope. Any ideas where I might look for problems? 

thanks in advance!