Hello everyone!
I'm trying to implement basic charting on a query that returns data like this
However when I click on the chart tool to add it to my form and select the query as the record source I get:
Either the table or query you selected doesn't have enough valid fields to provide data for a chart or the fields can't be retrieved. Select a table or query with at least one numeric, date, or text field.
It would seem I have that? Any ideas?
I'm trying to implement basic charting on a query that returns data like this
Code:
Category Question Scores
Infrastructure Vmware 1
Infrastructure NetApp 1
Infrastructure Tivoli 4
Infrastructure Citrix 1
Infrastructure Windows Clustering 8
Components Reporting Services 8
Components T-SQL 9
Components Analysis Services 4
Components Integration Services 3
Components Database Mail 9
Components SQL Agent 9
Components Linked Servers 9
HA Replication 9
HA Database Mirroring 8
HA Log Shipping 8
HA AlwaysOn 9
Maintenance Backup & Restore 9
Maintenance Recovery Models 9
Maintenance DB Creation & Configuration 9
Maintenance DB Roles & Security 9
Troubleshooting & Performance Monitoring Index Fragmentation 9
Troubleshooting & Performance Monitoring Blocking 9
Troubleshooting & Performance Monitoring Deadlocks 9
Troubleshooting & Performance Monitoring Database Flags 8
Troubleshooting & Performance Monitoring Activity Monitory 9
Troubleshooting & Performance Monitoring Execution Plans 9
Troubleshooting & Performance Monitoring Profiler and Traces 8
Troubleshooting & Performance Monitoring SQL Counters 9
Troubleshooting & Performance Monitoring DMVs 9
However when I click on the chart tool to add it to my form and select the query as the record source I get:
Either the table or query you selected doesn't have enough valid fields to provide data for a chart or the fields can't be retrieved. Select a table or query with at least one numeric, date, or text field.
It would seem I have that? Any ideas?