Answered by:
top N rows per group using fetchxml

Question
-
Is there a way to get Top n rows per group using fetchxml()? Can that be achieved in SSRS via fetchxm()?Saturday, January 11, 2014 5:10 AM
Answers
-
I dont think you could restrict number of data rows with FetchXML. Instead you could do it in the report designer.
- Proposed as answer by Payman BiukaghazadehEditor Saturday, February 1, 2014 1:00 PM
- Marked as answer by Payman BiukaghazadehEditor Sunday, February 9, 2014 8:53 AM
Monday, January 20, 2014 2:26 PMModerator
All replies
-
Hi,
I have not tested this inside CRM, but it works in ASP environments. Just test it to see if it works. The <Fetch> tag has a count attribute, set it to a number such as 5 or 10 to see if it works.
Saturday, January 11, 2014 6:30 AMModerator -
Yes that will fetch only N records for that data set. Is there a way to get N records for each group. If not whether this can be implemented via rownumber in ssrs.Saturday, January 11, 2014 4:21 PM
-
I dont think you could restrict number of data rows with FetchXML. Instead you could do it in the report designer.
- Proposed as answer by Payman BiukaghazadehEditor Saturday, February 1, 2014 1:00 PM
- Marked as answer by Payman BiukaghazadehEditor Sunday, February 9, 2014 8:53 AM
Monday, January 20, 2014 2:26 PMModerator -
Hi,
Try this
"<fetch mapping='logical' page= "1" count='N' distinct='true' version='1.0'>" +
Thanks,
E V Krishna
Tuesday, January 21, 2014 4:53 AM