+ Start a Discussion
King KooKing Koo 

Limit access to reports only via dashboard

HI there

I have a dashboard showing a donut.  When clicking a wedge on the donut, I have set it up so that the user will be brought forward to the filtered report showing detail information about the clicked wedge.

Is there any way so that I don't let user access the report directly?  That is, the only way they can get to the report is via the dashboard, so what they will get is always the "filtered report", not the whole report?

I tried to create a report folder with no sharing to the user profile, but when I signed in as the user, I got the "The data you were trying to access could not be found. It may be due to another user deleting the data or a system error." error.

ANy ideas?
Thanks
King
Sonam_SFDCSonam_SFDC
Probably what you can do is create a visualforce page and restrict users form the drill down to report fetaures which is something you cannot restrict users using the standard Dashboard functionality:
https://www.youtube.com/watch?v=IBQcywsJ0OE
http://vanityforce.wordpress.com/2013/02/03/two-methods-for-embedding-a-report-or-dashboard-chart-in-visualforce-or-standard-pagelayout/
http://salesforce.stackexchange.com/questions/8806/how-can-i-embed-a-dashboard-in-visualforce
King KooKing Koo
Hi Sonam

That's what I'm wondering.  VF always seems to be the answer to everything, but no in this case we're trying to use OOTB feature.

So this really can't be done using standard config then?

Thanks
k
David "w00t!" LiuDavid "w00t!" Liu
The good news is eventually your org will have so many reports that no one will bother finding that report anyway  =)

Thinking long-term, it might not be that bad of a thing if users can access the report, even if it is unfiltered. Eventually they need to be comfortable with adding their own filters to reports!

Otherwise, the only answer I have is Visualforce also  =(
Sonam_SFDCSonam_SFDC
I agree with David on this as is something not possible using the OOTB functionality and would require coding.