Post reply

SSRS experts please help and let me know if feasible at all in SSRS.

  • December 4, 2012 at 3:03 pm

    #285725

    I need to create a dashboard where i need to do the series grouping based on different columns in values tab..

    For example if the value field is column "COl1" then i need the series to be group by region if the field is col2 i shouldnt have any group in the series group..

    I am trying to create a secondary y_Axis but unable to accomplish the above logic.

    Something similar to below post..

    http://stackoverflow.com/q/9332401

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

  • December 6, 2012 at 11:24 am

    #1566280

    If I understand what you're looking for, I've done this in the past.

    Create a parent group on Details. INnstead of selecting a field, I used an expression like the one below:

    =IIF(Parameters!ParameterName.Value = "value1", "field_name1",

    IIF(Parameters!ParameterName.Value = "value2", "field_name2",

    ""))

    Then I would create a parameter with the option of differnet group types.

    I have done this plenty of times when users want the option to group differently.

    not sure if this is the route you're looking for, but hopefully it gives you a good lead.

  • December 6, 2012 at 2:56 pm

    #1566362

    Can you explain me a bit more..

    This is my req ,sorry if i havent explained correclty in first instance. need to create a dashboard where i have

    X- axis -- Months

    Y-axis 1 -- Units

    Y-axis 2 - Percentage..

    Series Group -- State

    Now i have to group the percentage by state which is a line chart ...where as the units is stacked area which shouldn't be grouped by state...So is there a way to not group the units by state and group the % by state in the same chart ?

    I have image of the dashboard in below link which i created in xls and need it in ssrs 2008 r2

    http://www.sqlservercentral.com/Forums/Topic1392221-1633-1.aspx

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

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

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