Avatar of cheryl9063
cheryl9063
Flag 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?
SSRS

Avatar of undefined
Last Comment
edlunad

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Andrei Fomitchev

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
edlunad

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

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
edlunad

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.
fblack61