Post reply

NthMostfrequent function

  • June 3, 2008 at 1:07 am

    #207994

    Hi,How to replicate the functionalities of Crystal's NthMostfrequent function in rdl?

    thanks

    -Meghna

  • June 4, 2008 at 8:02 am

    #824192

    If you can create a result set that for each item, also has the quantity or frequency of that item, and if you can use SQL 2005, you can then use the ROW_NUMBER function over the item identifier, ordered by the frequency or quantity in descending order. From that result, you simply select the item with ROW_NUMBER of N, for the Nth most frequent. Does that make sense?

    Steve

    (aka smunson)

    :):):)

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

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

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