Not having any luck with the Chart Visualizer to work. I think because of the complexity of query being performed, it is throwing an exception:
"Value cannot be null. Parameter name: type" because the Chart visualizer is attempting to populate the chart using columns that don't really exist in the table.
If I do a Grid, I get the "job" report results just fine such as:
| Month |
Year |
Requests |
Approvals |
Completions |
| 7 |
2007 |
20 |
15 |
14 |
| 8 |
2007 |
10 |
9 |
16 |
| 9 |
2007 |
9 |
12 |
15 |
Would it be possible to render the chart of the result set as opposed to dynamically building the chart from the query directly? Or am I mistaken in how it pulls the chart data?
If the 'chart' functionality was an extension of the grid visualizer, I could simply state my Axis titles and the chart (multiple line plots) could be built using the first row as the categories and the underlying results as the plot points, no?
Forgive any incorrect assumptions here... I'm not really a programmer, I just play one using DNN. :)