Hello all.  I recently created a post called "Hide/View Columns in SSRS" in which I described an issue I'd only been seeing when working with columns having visibility toggled by an object on the report.  Now I'm seeing the same behavior in a report that doesn't contain any hidden or toggle-able columns, so I'm re-posting.  I don't know how to delete the original post, or I'd do that.

Here's the original text:

"I'm converting InfoMaker reports to SSRS, and creating some new reports in SSRS, and making them available to run from Tessitura.  One issue I've been seeing comes up when I have columns that can be hidden/viewed.  When first run, the report renders fine; when I click to view a column that is hidden by default, it shows them with no problem; when I collapse/hide the column again is where the strangeness begins....

The report displays as it did before I expanded the columns, but I notice that the scroll bar indicates there's more to the report than there was before.  I scroll up and see that the report is duplicated at the top of the "page", unformatted (everything left-justified, no bold or italics), in what appears to be uni-code text, with the hidden columns displayed.  There is a lot of white space between the "good" version and this new version above it, and also a lot of white space below the "good" version.

Each time I display and hide a column, I get a new weird copy of the report appended to the top of the "page".

This only happens when I run the report from Tessitura; when I run it in SSRS, I don't see this behavior.  I've done a lot of searching on Google and MSDN and can't find anything like what I'm seeing, so my guess is that it's something to do with Tessitura.

I'm new to Tessitura, so I'm hoping that I've overlooked some setting that will prevent this from happening.  Any suggestions?"

But in a new SSRS report I just created, I'm seeing something very similar without the toggle-able columns.  In SSRS the parameters I'm using for testing result in a 4-page report; when run from Tessitura the same parameters give a report that indicates 4 pages, too, but when I get to the third page (the first two pages appear normal) I find that the data from the second page shows up with the same unformatted appearance, then some white space, then the third page of data as it should appear, followed by more white space.  The fourth page follow the same pattern - unformatted data from page 3, white space, page 4 data as it should appear, more white space.

If I print the report or export it to a PDF, this strange behavior doesn't show up there.  It's only when rendered on the screen from Tessitura.

What do the experts think?  Any help would be greatly appreciated!

Nathan