Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Report Builder 2.0 Repeat headers on new page (grouping expressions) Expand / Collapse
Author
Message
Posted Thursday, February 25, 2010 8:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 25, 2010 1:46 PM
Points: 2, Visits: 5
Hello everyone,

I have a tablix in my report designed with Report Builder 2.0. I am trying to get the HEADERS REPEAT on new page. I am trying to achieve this through grouping expressions.

I right clicked on the group belonging to the tablix (details_3 is what Report builder named it) and chose Group Properties, and on Grouping expressions, I had this expression: =RowNumber(Nothing) / 10. I also clicked on Page break section and checked "Between instance of each group".

Now, when I run the report, this particular tablix has headers repeating on new page but only one row per page shows up. WHat I am trying to achieve is have 10 rows per page.

Am I missing something? Any help would be greatly appreciated!
Post #872795
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse