Hidden rows breaking report into 1 row per page in SSRS VS 2010 Shell

Hidden rows breaking report into 1 row per page in SSRS VS 2010 Shell

I am trying to create a report that hides rows that have a particular
column1 value of 0 while still using the value in column2 in the sum
total. This behavior is working by going to advanced mode and setting the
Hidden property of the row I want to hide to
=iif(Fields!Column1.Value=0,TRUE,FALSE).
The correct rows are hidden, the total on the group is correct, however,
the report displays the first page as blank and then 1 row per subsequent
page both in preview and after deployment in IE. I also discovered that if
the report is exported to excel it puts each row into its own sheet. I
cannot find the cause of this as the report was displaying and exporting
normally before I hid the rows.