Well, that's clearly a tough nut to crack.   Nothing could realistically guarantee a lack of complexity, save a hard limit on the total number of expressions, operators, and parentheses.   As...

And one more thing:  Your dynamic query starts with UNION ALL...  and that's going to cause a syntax error.   Not sure why you have that in there, and maybe you...

Okay ... time to throw my hat in the ring...   I would not recommend storing the data in the database this way, as it's just not a proper representation of...

• This reply was modified 5 years, 3 months ago by sgmunson. Reason: grammatical

Yep. wouldn't be surprised.   I've solved the problem but not the issue...

Anyway, maybe you can help me with my current problem, which I'll be posting shortly...

FYI, I was converting this report from Crystal Reports, and the problem was largely of my own making.   I chose to talk to the person supporting that report, and they...

Excellent!

I hear you, but make your dataset provide those values...  and the problems go away.

If I were you, I'd never rely on values derived in the SSRS report.   I try to compute all the values I need in my query that feeds the dataset,...

I hear you on dynamic SQL, but I think I'd have to be concerned about a system that can generate 62GB of data in tempdb as it may well be...

BUMP.....

I'm getting nowhere on the MSDN site...   Would really appreciate any assistance of any kind at this point.   Just don't understand why this is occurring and all MSDN support is...

Here's a link to the details posted on MSDN:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6a43e7ce-c1d6-4624-8eef-48dea5667475/ssrs-report-fails-to-show-header-columns-on-the-last-page-only-when-that-page-has-only-1-subgroup?forum=sqlreportingservices

There could be some ugly consequences in some cases if existing legacy data has trailing spaces contained in varchar data type columns, as both tables and indexes could get a...

No response, eh?

Okay...  well, here's more details:

This morning's testing indicates that this only occurs when the last page holds a single instance of the fifth group and all it's sixth...

Interestingly, no one has mentioned SQL Server ""replication".  It CAN handle schema changes and copy stuff over to a different database or even such on a different server.  The question...

Michael,

As DesNorton has already indicated, the ONLY way to guarantee a given order of the output rows, is to use ORDER BY.   What has occurred in your first picture is...