Post reply

SSRS Pie chart

  • February 27, 2017 at 6:30 am

    #335403

    Hi,

    I have to create a pie chart with 2 cuts 1 has a value that is know , Eg 2000 then the second one will get values from a query (Broken)    Is there a way to have achart like that

    All CarsBroken

    2000504

  • February 27, 2017 at 7:04 am

    #1930468

    There's a truly easy way to do that.   Add the following to your query:


    UNION ALL
    SELECT 2000 AS yourexistingfieldname

    If there are other fields in your query, then you may have to stub in some other values to allow the UNION ALL to work, but it shouldn't be that challenging.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • February 28, 2017 at 3:33 am

    #1930643

    Hi,

    Thank you for the help but now it shows the below even if existing file has a name

    Broken
    504
    2000

    and I would like it  to show

    Broken  All cars
    504       2000

  • February 28, 2017 at 3:40 am

    #1930644

    Just declare a static value column?
    SELECT [YourField] AS Broken, 2000 AS AllCars
    FROM [YourTable];

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • February 28, 2017 at 4:08 am

    #1930649

    Perfect🙂

  • February 28, 2017 at 2:33 pm

    #1930826

    You'll need to modify your data source query as Thom suggested.  I misinterpreted your earlier post.   If you can share your data source query, we can show the modifications.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 6 posts - 1 through 5 (of 5 total)

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