There is insufficient data to display the requested chart subtype for this report. Try using another chart subtype.
STEPS TO REPRODUCE:
Follow the steps below to reproduce this problem in the Strategy Tutorial project:
- Create a graph report with any graph type, place Year, Category on the row and Cost, Revenue on the column.
- Use the graph report created at step 1 to build a Report Services Document.
- Use Year as attribute selector and target the graph report, enable the option "show total" in the selector property editor.
- Run the Report Services Document in Interactive mode or Flash mode, choose the Total element for Year selector. The error message should be displayed: "There is insufficient data to display the requested chart subtype for this report. Try using another chart subtype."
CAUSE:
Graph does not show subtotals by default, they have to be enabled.
ACTION:
Follow the steps below to enable the option "Show subtotals" under the graph formatting editor:
- In the interactive mode of Report Services Document, right mouse click on the graph and select "Format" to bring up the graph formatting editor, then go to advanced tab and check the option "Show subtotals", as shown below: