I have a DataSet defined which uses a SELECT TOP 5 to return 5 rows only. Each row contains a name and a value, so it might be:
I want to show these five points as pointers on a gauge. FRED and IRIS I can do as I can get MIN and MAX values (I would like to show the name as a tooltip but I'm not sure how to reference the name).
Can I specify as the pointer data value the value for either a particular ordinal (first, second, third etc) or can I obtain the value based on a hard-coded name.
Any help appreciated.