Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Adam West
Constraint Violating Yak Guru
261 Posts |
 Posted - 2009-07-24 : 12:04:23
|
| I am interested in some of the highlights you may have found in Reporting Services 2008 vs. 2005? |
|
|
yavvie
Starting Member
46 Posts |
Posted - 2009-07-27 : 08:51:12
|
| Hmm... the negative one is the design environment: when you have an expression on what is displayed instead of showing the beginning of the expression in the field it shows <<Expr>> and you have to click to edit the expression to learn what is in it.Second thing - in matrix (now tablix) you cannot have by default hidden fields that might have sublevels like you could in 2005 - then the sublevels arent shown either (we had this when we had a matrix and some lines could contain in one of the main rows more lines and some couldn't, so on those we had default hidden and 2008 then hid everything connected to that line/level).I don't remember if it worked in 2005, but if you have a drillthrough matrix you cannot have a subreport in it (links yes but not a subreport directly in the matrix).Reports are a little bit faster but nothing too great.There is the new possibility to "Consume white spaces" usable especially if you have different views of one report that change its size so now it is printable in a better way.About 50% of reports from 2005 won't work correctly so you'll have to check everything really carefully.Parameters and datasets in the design environment changed place to the left side and the list of parameters keeps on hiding when you switch to a different tab.Groups on matrices are simpler and clear as they are shown in a separate window where you can edit them.I'd say you should wait till SP2 :) We have only about 150 reports and we spent some 30 or more workdays just fixing the problems with the new reporting server and even after SP1 some reports still wouldn't work correctly. If you have only simple reports there are almost no problems, but if you use visibility and matrices a lot then its hell. |
 |
|
|
|
|
|
Improvements over 2005