SSRS 2008 Chart Question

  • Hello!

    I have the next data that a query returns. (see attached).

    The data have to be order like that, the only thing is sometimes the ODE data is not return (thats normal).

    Here is my question, without modify the query, is there a way the chart only draw one line instead of two?

    Here is what I need, when the table has ODE data, the chart only draw a line for ODE. When it doesn't has ODE, draw a line for Actual only.

    Thank you very much!

  • Please clarify the scenario. Are you saying that ODE will sometimes never apply, or that ODE may not always be paired with the other data?

    If you only get one dataset, the SSRS chart will only draw a chart element for that dataset. If ODE is not in the dataset, the components will know nothing of ODE, preventing any chart elements from being drawn.

    Hope that is the answer to the correct question.

  • ODE may or may not be on the dataset result.

    Actual always will be on the dataset result.

    When there is no ODE data, there is no problem, only show one line for the actual.

    When there is ODE data, I need to show only ODE data and not the actual.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply