none
TOP 5 returning 10 ???? :( RRS feed

  • Question

  • Okay here is my delema.. I have a embedded chart in a table that returns that is set up to return the top 5 of it's sub-children... got me?

    So if i look at info of the datas' children i see

    Parent Data

    Infoasd

    Count

    Pdataasd,asd,as,d

    123

    134

     

    Get these top 5 for chart ----------->

     

    Child Data

    Count

    Infower

    56

    Infower

    43

    Infower

    23

    Infosadew

    2

    Infoasd

    2

    Infoasdui

    2

    Infoasda

    2

    Infodasdas

    2

    Infoqweqw

    2

     

    Now as you can see at row 4 on the child data  the count is 2 and then 2 and then 2 and so on...

    Now the chart returns all of this down to 1 (not includeing the 1).. why?

    Am i just confused and top n really mean the top 5 values and not the top 5 rows.

    If it does mean values how can i only grab the top 5 records of a result? 

    Thursday, July 6, 2006 8:58 PM

All replies

  • Help me out here, pleaseeeeee  
    Friday, July 7, 2006 1:13 PM
  • The top and bottom filter operators in Reporting Services currently always include "ties". That's why you get more than 5 records in your example.

    Maybe you can modify your query to perform a top 5 operation already there?

    -- Robert

    Friday, July 7, 2006 3:41 PM
  • That is what i was afraid off. I do not want to modify the query as this is a very small part of the query. I only want tot show 5 of say 500 records that can be show by doing a unhide.

    What is this "tie" you speak of?

    So if i can not use top 5 then is there a way to get just the top five rows programatically?

    Friday, July 7, 2006 3:59 PM
  • Did you ever get this resolved? I have the same problem.
    Wednesday, January 17, 2007 5:14 PM
  • Did you try using the RowNumber value to conditionally hide the information?

    http://msdn2.microsoft.com/en-us/library/ms159225.aspx

    cheers,

    Andrew

    Wednesday, January 17, 2007 7:47 PM