Forum Discussion
Solved
Pulling in data from SQL server based on a search combo box
Hello, I need help setting up a dashboard where the user or several users can get data based on a search of the client name and date of birth. The database has about 75 million rows and it ...
rajaa2525 , if this is a direct query connection
Create a parameter page first
Need Traditional Parameter Page: https://www.youtube.com/watch?v=F3qMwQtWjvo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=15
make sure you have separate client and date tables
New means to access display pages - Display only one page in the report, Hide rest: https://youtu.be/d4H0GKUH0r4
amitchandak
Super User
Super Userrajaa2525 , if this is a direct query connection
Create a parameter page first
Need Traditional Parameter Page: https://www.youtube.com/watch?v=F3qMwQtWjvo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=15
make sure you have separate client and date tables
New means to access display pages - Display only one page in the report, Hide rest: https://youtu.be/d4H0GKUH0r4