December 20, 2007 at 3:10 am
Hello, a work collegue of mine has run into the following problem and I thought you guys might know about it. Doesnt seem to have much on the web about it, and decided that you wizards would have the answer. I have literally copied this from another forum where somebody else has posted the same problem we have.
We have run into a really bizzare problem after upgrading to SQL Server 2005 SP2. We have a bunch of matrix reports that have interactive sort in the upper left hand corner, the sort based on Numeric and Text fields. For Example
=Fields!City.Value
=Sum(Fields!Pax.Value)
Now for whatever reason after upgrading to SP2 and making NO CHANGES to the reports or under data sources, interactive sorts that use the =Sum(....) no longer work but interactive sorts on text values still work.
Any ideas???
Regards,
D
December 20, 2007 at 6:26 am
I have never heard of this problem before, but there were a number of RS changes from sp1 to sp2.
You should look carefully at the fix list for the service pack and see if there is anything related to functions or sorts that may have impacted your reports.
December 20, 2007 at 7:27 am
Hello, Thanks for the reply.
I have had a good look already but I do not find anything that is specifically related to this problem. I wonder if it may be resolved with a restart of the service or something simple like that.
Regards,
D
December 20, 2007 at 7:44 am
It's worth trying, but I think the service pack cycles IIS when it installs.
You should also open the report from the server itself using visual studio and see if it acts differently. I would then re-deploy it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply