Forum Discussion

hellgoingon's avatar
hellgoingon
Helper II
9 years ago

Using parameter in SQL server and map value of this parameter to filter control in report

Hi all,   I'm having a big data in AA table which i cannot run query "select * from AA" because it will cost me 2 hours to run query. So i've just want to display data defaultly from July 1st to J...
Need Help
hellgoingon's avatar
hellgoingon
Helper II
9 years ago

Thanks. There are anyways to access value of controls (on report) in Advand editor? 

    • hellgoingon's avatar
      hellgoingon
      Helper II
      9 years ago

      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?