Hi I am having trouble with a chart. I've using a stored procedure to retrieve data of 3 columns: username (varchar), datepicked (datetime), pickresult (which I use a case statement to change a boolean to string). The pickresult is giving me problems, in the sproc it looks fine:
Case Result
When 1 Then 'Won'
When 0 Then 'Lost'
End as PickResult
The problem is that on the report, it treats the column like a number rather than string. For example, if I print off the labels of the field, it has 1 and Won, 0 and Lost, etc.
Here is my report setup: datafield - pickresult, series - username, category - datepicked.
Basically I want the report to look something like this:
|
won / lost | * *
|---------*----------*----
(date values)
But I want the stars joining up (line charty), and want 2 lines (representing the 2 users).
Any ideas?
Thanks, Dan