none
Report Builder 3.0: set start or end indicator value to infinity? RRS feed

  • Question

  • Is there a way to set the Start or end values of the range to either +/- infinity?  For example I have a RYG indicator that is

    0-90 days green

    91-103 days yellow

    103+ days red

    For practical purposes I can set the "end" of the red range to be a large number, but it's really all numbers > 103


    Terrie T - MCTS - PMP - MBA****PMO & Project Server Admin
    Tuesday, August 30, 2011 2:36 PM

Answers

  • If you leave them blank, we treat them as Infinity.

     

    Regards,

    Sean


    Program Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs
    Thursday, September 1, 2011 2:33 AM

All replies

  • Hi Terrie,

    Thanks for your question. As far as I know, we couldn’t set the infinity value for the regions in indicator, indeed we couldn’t use one value with operator, such as “>103”.

    To work around this, I would suggest you use Max() and Min() function to get the maximum value and minimum value in the dataset, meanwhile set them as the boundary values.

    For instances:

    =Max(Fields!YearlyIncome.Value)

    =Max(Fields!YearlyIncome.Value,"AdventureWorks")

    =Max(Fields!YearlyIncome.Value,"AdventureWorks",Recursive)

     

    =Min(Fields!YearlyIncome.Value)

    =Min(Fields!YearlyIncome.Value,"AdventureWorks")

    =Min(Fields!YearlyIncome.Value,"AdventureWorks",Recursive)

    Hope them help you. If you have any other questions, please let me know.

    Thanks,
    Sharp


    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    Thursday, September 1, 2011 2:13 AM
    Moderator
  • If you leave them blank, we treat them as Infinity.

     

    Regards,

    Sean


    Program Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs
    Thursday, September 1, 2011 2:33 AM
  • Perfect, leaving blank did the trick. 


    Terrie T - MCTS - PMP - MBA****PMO & Project Server Admin
    Thursday, September 1, 2011 12:58 PM