Post reply

Generate Random Number in SSRS

  • June 17, 2014 at 1:32 pm

    #294448

    Can anyone out there advise me on how to generate a random number within in SSRS by means of a function and/or expression? I understand this can be done using TSQL, I would like to know how to accomplish this within SSRS.

    My attempt so far is: =RunningValue(Fields!qty.Value, COUNT, Nothing)

    Which is not random enough...

    Thanks in Advance for any help!!

  • June 18, 2014 at 4:04 am

    #1722668

    Rnd is a random function

  • June 18, 2014 at 7:53 am

    #1722805

    Thanks Jo for the reply. The rnd function certainly does what I need. My only problem now is that I want to only display the numbers after the decimal.

  • June 19, 2014 at 4:42 am

    #1723151

    Can you give an example of "only display the numbers after the decimal related to random"?

  • June 19, 2014 at 4:51 am

    #1723154

    GBeezy (6/18/2014)

    Thanks Jo for the reply. The rnd function certainly does what I need. My only problem now is that I want to only display the numbers after the decimal.

    You could treat it as a string, search for the decimal seperator and take everything that comes after it.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 19, 2014 at 4:52 am

    #1723156

    Koen Verbeeck (6/19/2014)

    GBeezy (6/18/2014)

    Thanks Jo for the reply. The rnd function certainly does what I need. My only problem now is that I want to only display the numbers after the decimal.

    You could treat it as a string, search for the decimal seperator and take everything that comes after it.

    Or if you want a fixed number of decimals, let's say 3, you can for example multiply by 1000 and then take the modulo of 1000.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 20, 2015 at 12:29 am

    #1791925

    CEILING(RND()*1000)

    Might help someone.

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy