Use the Static rows properties and set them to True-After-True to repeat the headers on each page.

The Static rows are visible in the Grouping pane expanded mode.. Set the Keep...

set the properties of the (Static) row to the following:

Keep Together--True

KeepWithGroup--After

RepeatOnNewPage--True

You will see the row headers repeating on every page. Do the same for all other static rows you...

Go to the Tablix Properties and uncheck the boxes: "Keep header visible while scrolling", both for rows and column headers. this will take care of you.

If you just open the page number expression dialogue box and rewrite the same expression or click OK button on the expression dialogue box, and run the report. you will...

I am following a book on 2008 SSRS.

"Applied Microsoft SQL Server 2008 Reporting Services" by TEO LACHEV

Good Luck.

Put the pagenumber in the report Header/footer and refer that textbox from body using the ReportItems!Textbox.value with in the IIF function to control the visibility of the data in the...

I'm also seeing this issue with the image exporting. Guys Let me know, if anyone could able to find the cause for it.

Click the cell you set to hidden and go to the properties window and change the "Data Output" option to "NO OUTPUT" from AUTO.

Did you install the SSRS 2005 on Vista home edition? I tried in lot ways to do that couple of years back. Almost tried to throw my computer outside.

As far...

I think Alex's solution works with SSRS 2005

But SSRS 2005 wont support the nested report items, while exporting in to Excel.

That limitaion was fixed in SSRS2008. if you could able...

what version of reporting services are you trying to install on windows 7?

Is it SSRS 2005 or SSRS 2008?

becoz 2005 version depends on the IIS and you can not...

Can you able to confirm me that, are you getting the query executed when you pass the blank values to the parameters and the way you want to see in...

I ran in to the similar situation few months back and the reason for this is: for 2005 reporting services, Excel does not support the nesting of the data regions.

But...

Use the IIF instead of Switch

Allow the blank values to both the parameters and get the results data from the main query passing either of the parameters.

select * from dbo.server

where server in (@server) OR...