We have created a report from a container off a SQL View. This brings across a huge amount of data with which we can get all the required reports. The problem being is that when distributing the data sheet stays behind and such the slicers do not work. We are not really wanting all this information off the datasheet to be distributed as it obviously contains some data that we do not wish to come into the wrong hands also the datasheet makes the file 40MB each time and this is too large to…See More
When a report is run, the raw data is placed in sheet 1 of a report. Since you are not using the Report Designer you can create and edit a Pivot Table to view the data as a report. The Pivot Table can be refreshed every time the report…"