Can anyone see what's wrong with the following? It's been bugging me for ages as I can't see any problem withit.
=First(Fields("gradient_colour" & Fields!Response.Value).Value, "uspGetReportSettings")
This is setting the background colour of a textbox. The value in the text box is percentage from the dataset "feedbackResults", Response is a column from that dataset. uspReportSettings is a generic sp that returns all the report settings in a single row. In this instance, Response returns 5 and when I call:
It works fine.