Hi All I am using RS 2005. I have a table that has an expression for its hidden property. whenever i try to export this table to excel (after the report has rendered) I get all the Groupings on the same excel sheet as oppose to splitting each group on its own sheet. I have already checked the "page break at end" property in the grouping and sorting properties but that does not do anything if there is an Expression for the Hidden field. If I don't have an expression in the Hidden property and its strictly set to true or false i get the groups separated on different sheets just fine.
I am desperate for a solution, please help. Thanks in advance I. Brock
