Post reply

SSRS Scenario Chart

  • December 1, 2011 at 3:59 am

    #260614

    Hi

    I have to create a chart report in ssrs as per given below condition

    For example: In a patricular year my company revenue is less than 50 billion

    then the corresponding bar has to be reversed.(As the picture given attachment)..

    Can any one help on this....

    |

  • December 8, 2011 at 3:01 am

    #1418549

    Within the dataset query add a case statement to change the Revenue figures to -ve. When you add this dataset to the graph that will automatically take care of the bar reversed.

    eg query:

    SELECT [AnnualRevenue]

    ,Case When [AnnualRevenue] < 90000 Then [AnnualRevenue] * -1

    else [AnnualRevenue]

    end as NewAnnualRevenue

    ,[YearOpened]

    FROM [AdventureWorksDW2008R2].[dbo].[DimReseller]

    hope this helps, good luck

  • December 13, 2011 at 9:28 pm

    #1420985

    Hi natraj,

    Thanks for the reply.....i didn't check the mail last week

  • December 14, 2011 at 4:34 am

    #1421155

    Hi nataraj,

    Thanks i got it.....:-)

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

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