Full SharePoint List Filter

[Djtimestamp]

Hi Everyone.

i have 3 SharePoint lists with about 50 columns each. Without appending them, is there a way I can get a Table visualization to show all the data for a SP list, then have a filter/dropdown of the data sources, and change the table visualization that way?

my current design is just to create 1 page for each SP List but I'd like to be able to consolidate it to 1 page.

[lbendlin]

 I'd like to be able to consolidate it to 1 page.

and you want to do that without appending them?

[Djtimestamp]

Yes, im trying to see if there is a way to essentially switch data sources as a drop drown/filter instead.

this is because its alot of data to Append.

i can do it the long way of creating a page/tab for each table. But looking to see if there was a cleaner or easier way to do it

[christinepayton]

You can swap datasources using parameters, but it's not something your report viewers would be able to do. You might break up the processing a bit by putting the connections in a dataflow, then appending them in the desktop from there - the connection to dataflows is much faster than the connection to SharePoint.