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
- lbendlin
Super User
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
- christinepayton
Most Valuable Professional
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.
