Ask Search:
Amy NordenstromAmy Nordenstrom 

Dashboard error message - report can't be used as the source

Error: This report cannot be used as the source for this component. If it is a summary or matrix report, add one or more groupings in the report. If it is a tabular report with a row limit, specify the Dashboard Settings in the report.
Amy NordenstromAmy Nordenstrom
I keep getting this error message and I don't know why or how to fix it.
Steve MolisSteve Molis
Can you post a screenshot of the Dashboard Component and the Report you're using?  The error message is usually pretty straightforward.  Have you changed the report to Summary or Matrix format?
Jeff LockardJeff Lockard
I have the same error for a summary report that is grouped by a custom formula field (text).  When I change the group by on the report to be date (month), I don't get the error anymore.  Could it be because the Group By is based on a particular type of field?
Kyle OrtmanKyle Ortman
I was having this issue also. I added a few columns to it, and sorted the data by date (read only) then saved.
Steve MolisSteve Molis
Hi Guys,

Some screenshots would be really helpful.  As you saw with Kim no screenshots and no follow-up = No Solution
Kyle OrtmanKyle Ortman
User-added imageAfter working on this for a while, I found that you need to add a grouping in the report. There is nothing to chart if you don't tell the report how to group it.



Steve MolisSteve Molis
Yes, that's pretty much what they mean in the error message Kim posted: 

Error: This report cannot be used as the source for this component. If it is a summary or matrix report, add one or more groupings in the report.  If it is a tabular report with a row limit, specify the Dashboard Settings in the report.
prasanth salesforceprasanth salesforce
Hi, Amy Nordenstrom the error is dispalyed when we are creating dashboards with reports. When we are creating report types in salesforce we have to select summorized information by option by any field. If we forget to add that field the error will be dispalyed when creating dashboards. For clear information about this error browse the following link. Reports in Salesforce (http://www.crmsalesforcetraining.com/creating-custom-reports-in-salesforce/)
Salesforce tutorials
Peter ThompsonPeter Thompson
We had this problem too - it turned out it was down to field visibility: the field we were grouping by was not visible to the user the Dashboard was running as.  Increased the field visibilty to include the dashboard user and Bob's your uncle.
Jolene Scott-MartinJolene Scott-Martin
Peter, thank you for your answer - I couldn't figure out what was going on.  I knew I had grouped the report, but after seeing your comment I checked whether the running user had been given access to the custom field on which the report was grouped, and guess what? He didn't have visibility on the custom field.  Changed the permission and now it's working fine! It's taken me days to find this answer! THANK YOU!!! :D