I've got a report I'm working on. It generates two views and uses one table directly. The report contains information from the two views and table. Only one of the views/table is appearing on my report. If I select view 1 right before running the report, that's what shows up on the report (view 2 and table info are missing). If I select the table instead, both views are missing. I'm not using the data environment in the report since the views are generated on the fly. The fields of the views and table are all referred to using:
v_View1.Field1
v_View2.Field1
Table1.Field1
Why wouldn't this work?