Link to home
Start Free TrialLog in
Avatar of cheryl9063
cheryl9063Flag for United States of America

asked on

SSRS tablix rows

I have an SSRS report with a matrix is what you call it.. Anyway this is someone elses creation.. One of the rows has a word (expr) in it from a parameter.. When you print out the report it prints out in about 10 pages.. I only want that word(expr) to show on the first page.. How do I do this?
ASKER CERTIFIED SOLUTION
Avatar of Andrei Fomitchev
Andrei Fomitchev
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Check this link on section "To hide static rows in a table, matrix, or list"

http://msdn.microsoft.com/en-us/library/ms159830(v=sql.100).aspx

Avatar of cheryl9063

ASKER

This is helpful but my tablix HAS to be based on page number or rownumber is fine..See screencast below.. If the page number(from the footer) is 1 then display else display nothing.. I cant change the grouping of this row or it messes up everything else.. The row hiding thing does not work.. I ONLY want the word PAGE to show on page 1..Unfortunately in a tablix you cant refer to the page number only in the header or footer.. Is there a way in the tablix to refer to a page number or row number..?? PLease dont give me a link to read just tell me the answer.. Thanks
cheryl9063-486883.flv
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial