Forum Discussion
Using parameter in SQL server and map value of this parameter to filter control in report
So how can i solve below problem: I have data from 2008 -> now (2017). Data of each years are round 100,00,000 records. So 9 years = nearly 1 billion records.
Time of loading data (2008 -> 2017) are over 2 hours. Absolutely i cannot load all data each time accessing report page. so i load data in only current year (2017) to speedup loading.
But the problem is if loading data in 2017, user cannot filter data in 2008 -> 2016 whatever they do on report page.
So how can i do: loading data in only current year (2017) but user can see data of 2008 -> 2016 via filter on report page?
Yup! i already use DirectQuery but it query all data when loading report -> That makes speed very slow. After query all data, it will display data base on filter controls on reports