SQL Server Performance

Line chart serties to start at 0

Discussion in 'SQL Server 2008 Reporting Services' started by bubberz, Jan 31, 2011.

  1. bubberz New Member

    I have a line chart series that is for accounting.

    A sample query would pull back 12 rows (1 row for each month, Jan - December), and the columns would show the dollar amounts for separate buckets of money allocations.

    What I'm trying to do is have the series chart line start @ 0 (we're trying to mimic another chart that does the same thing).
    Right now, the chart line starts at the January amount, say $10,000 for example for the first month data value.

    I'm not seeing a property on how to do this...would I need an extra/13th row of 0 values to get the starting point?

    Thank you!
  2. satya Moderator

    Not sure it is possible or not, see if you can Axis Properties for that value.
  3. Anton Bahchevanov New Member

    Hello,
    with the standard chart you'll need an additional dummy record to achieve that.
    Nevron chart can solve the problem using custom C# code injected in the report...
  4. Luis Martin Moderator

    Advertising is not allowed in this forum.
    Please contact our Administrator.

Share This Page