Forum Discussion
Full SharePoint List Filter
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.
3 Replies
I'd like to be able to consolidate it to 1 page.and you want to do that without appending them?
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
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.
