I have a SQL VIEW which joins multiple tables. Created a SF BO based on the view. Then a Custom BBS. Then a user control to fire off a Sharpshooter report. There are parameters on the user control and a button the user clicks to then run the report. The click event of the button does a SELECT with a WHERE clause to narrow down the data. My question is to confirm whether the SF Framework is waiting until I issue the SELECT to fill the BO, or does it fill it automatically initially with all the data and then refill it when I issue the SELECT.?

Like in FoxPro you could use a view with NODATA returned until you actual fill the view.