How to show top n rows in a table

• BKW

  Ten Centuries

  Points: 1350

  More actions

  February 24, 2009 at 8:27 am

  #197448

  I have a table in a report that I only need to print the first 3 rows. I am using report viewer with website data source so I can't do a separate dataset.

  I tried this and get the error below:

  = IIf (CountRows ((Fields!First_Name.Value) &" "& (Fields!Middle_Name.Value ) &" "& (Fields!Last_Name.Value)) >3,false,true)

  Error: The Value expression for the textbox ‘EX_Name’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set.

  Changinagain

• nigel.c.west

  Hall of Fame

  Points: 3468

  More actions

  February 24, 2009 at 8:43 am

  #949443

  Hi

  The way to do this is to go to the properties of the table, then go to the filters, and add a filter in with an operator called TopN.

  Should be relatively easy from there.

  Regards,

  Nigel.

  Nigel West
  UK