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
Any helps please?
  • 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?