When I upgraded the project from 2005 it defaulted this value to 2008.

After a while of fiddling with it and not getting it to work I tried changing...

I've tried in both IE and Chrome... both have the same problem. I tested last night using SQL Server Express Edition Adv 2012 and it works fine.. it appears...

Thank you so very much for that information.. That is great news.

Tom,

Are you working on 2005, or in 2008?

David

=First(Fields!GROUP9_BORDER_LEFT.Value, "ROW_FORMAT")

Its the same basic expression that I use to set the Font, Font Color, Format, Background Color, etc... and they...

I agree Andy.

I use this method all the time...

I have lots of reports/queries like this, and its the only way I could find to make it work......

Yes, the textboxes in the Expression are part of the report...

They are nested groups... if GROUP9 isn't being used I want it to remain Hidden, and use a textbox from...

I worked in Crystal 8.5, I can't speak for newer versions... and I work in SSRS 2005, and 2008/2008R2. I live SSRS reports better than Crystal. I like...

Thanks for all the help everyone...

After a few hours now of step by step tests... I found the problem...

I was not aware that the scope of the "set rowcount" statement...

The calling program is in a loop - WAITFOR cycle. When it finds a records in the JobQ with a execute time <= getdate() then it does a set...

That looks like a great article, not exactly what I asked for, but it looks like it may be even better.

Thanks...

Here is a more detailed explaination of what I am doing...

I am using Excel as a modeling tools for a report writer. The actual business logic and data are...

I agree if we could do set-based updates it would be better. However, as long as its still in an Excel file that's not an option.

If I can get...

The data is indeed loaded into Excel in a loop..cell by cell. This is because each cell is the intersection of Column criteria and row criteria. After the...