My users would like to view detail level data, but since the details tab on my workbook can have over 3 million records (and growing of course) - viewing the entire listing is not an option.
How can I display a subset of data and give the users the option to export the full listing?
I have created the worksheet with a filter to limit the dataset to the first 1,000 rows with a true/false filter. If the rows exceed 1,000 - there is another sheet that populates on the dashboard that says - Please export to view all records - Displayed Records = 1,000 Total Records =x. There is also a export picture on the page with a url attached to it. The URL is the same page name with the filter (for 1,000 rows) in the parameter and a format of csv. The other issue I could have is that we have 1,000+ custom views on this dashboard.
Example:
DashboardReportsTest/Details?:RankFilter=False,True&Format=csv
I would like the same end result that we see when we go to export data - the first 200 rows showing with the option to export the entire listing.
Any help is greatly appreciated!!
Kristy, I'm guessing this can't be done.
Cheers,
--Shawn
