yes,there is an option to repeat the header rows on every page for a Matrix in SSRS 2008.

Go the Matrix properties-->>Column Headers and Check Header columns on each page.

Try using UNION in the query used in the dataset for passing values to the parameter.

When you do a union say SELECT 'All' AS category FROM Table1.

Add a...

Make sure (Body Width + Left margin + Right margin) <= (Page width) on the report.

This should be solving your problem.

Thanks,

Nemo8

Thanks for the reply.

But how do i change the link? I Am actually exporting the report from share point.