reportviewer chart problem RRS feed

  • Question

  •  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

    Thursday, August 7, 2008 4:31 PM