Trying to confirm something about Sharpshooter filter parameters within Sharpshooter itself.

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.

Hi Trent,

I am newbie to SF.

Can u supply me a good working example using this technique in reporting?

Kind regards....

Hi Hector and welcome to the forums.



There are several RSS samples in the forums, just do a search using "sharpshooter" to find those messages.



Also the StrataFlix sample application uses this technique but with .Net Reports instead, but you can get the idea on how to implement it.

Edhy Rijo