I have a VIEW that defines what tables need to be related and how. Created a SF BO to be able to map the VIEW to a BO. Then created a Custom BBS on the BO.
Naturally until a call is made to fill the BO no data is filled.
If you reference the BBS in the Sharpshooter report as a Datasource, then put filter expression on the report as parameters, will Sharpshooter return:
A. All data to fill the BO and then filter based on the Sharpshooter filter expressions? , or
B. Does Sharpshooter generate a SQL SELECT with the parameters already built into the SELECT statement thereby returning only the ropws needed?
From what I can see, I believe "A." is what Sharpshooter does.