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
TOP 5 returning 10 ???? :(
dg2007
R.Tutus
Did you try using the RowNumber value to conditionally hide the information
http://msdn2.microsoft.com/en-us/library/ms159225.aspx
cheers,
Andrew
ArcPadNewbie
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
Yonglun Li
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
Shyamal Patel