Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Report builder 3.0 - gauge

Answered Report builder 3.0 - gauge

  • Thursday, March 07, 2013 8:06 AM
     
      Has Code
    Sign In to Vote
    0

    Hi

        Is it possible to show on one gauge two or more values from one column? For example I have table from SELECT like below and I want to have two pointers in one gauge. First showing value 2 and second 3.

    SELECT [GroupName], COUNT(NAME) AS NameCounter
FROM [AdventureWorks2012].[HumanResources].[Department]
WHERE [GroupName] IN ('Research and Development', 'Manufacturing')
GROUP BY [GroupName]

    Results:

    GroupName                   NameCounter
    Manufacturing               2
    Research and Development    3

    Kind regards,
    Jerzy

    everything is a matter of probability...


    • Edited by pen_2 Thursday, March 07, 2013 9:37 AM
    •  
     

All Replies

  • Thursday, March 07, 2013 10:52 AM
     
     Answered
    Sign In to Vote
    0

    Ok. I found solution. The value of both pointers must be a conditional expression. In above example value of first pointer should be

    =SUM(iif(Fields!GroupName.Value = "Manufacturing", Fields!NameCounter.Value, 0))

    and second

    =SUM(iif(Fields!GroupName.Value = "Research and Development", Fields!NameCounter.Value, 0))

    I though that it can be done using somekind of grouping in gauge options and assigning pointer to that group. If anyone have other solution please share.

    everything is a matter of probability...

    • Marked As Answer by pen_2 Thursday, March 07, 2013 10:52 AM
    • Edited by pen_2 Thursday, March 07, 2013 1:29 PM
    •