SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


10 Bad Things About Reporting Services 2008 R2


10 Bad Things About Reporting Services 2008 R2

Author
Message
AndyOwl
AndyOwl
SSC Veteran
SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)

Group: General Forum Members
Points: 266 Visits: 182
Comments posted to this topic are about the item 10 Bad Things About Reporting Services 2008 R2

Andy is a director of Wise Owl, a UK company providing training courses (and occasional consultancy) in SQL, Reporting Services, Integration Services and Analysis Services, as well as in many other Microsoft software applications. You can see more about Wise Owl's SQL Server training courses here.
John Power
John Power
Valued Member
Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)Valued Member (69 reputation)

Group: General Forum Members
Points: 69 Visits: 80
I find the lack of "Paste Format Button" the most annoying thing - if it was available it would be a big time saver.
peterw 85974
peterw 85974
SSC-Enthusiastic
SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)

Group: General Forum Members
Points: 136 Visits: 9
Paste Format be damned, I want a stylesheet editor that interactively shows the effect of styling on tables and text, with the option to use my own report as the sample.

They can crib from Microsoft Frontpage, or Microsoft Expression Thingummy.

And for god's sake port the damn thing to VS2010.
peterw 85974
peterw 85974
SSC-Enthusiastic
SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)

Group: General Forum Members
Points: 136 Visits: 9
And a renderer for XAML so reports can be rendered directly into the UI of a WPF/Silverlight application without a lardass third party report viewer control.
Daniel Hallam
Daniel Hallam
SSC Veteran
SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)SSC Veteran (234 reputation)

Group: General Forum Members
Points: 234 Visits: 398
the lack of exporting to .xlsx is my number one hatred but the article definitely rings true
davoscollective
davoscollective
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3117 Visits: 1008
Format painter ! I wish for that daily. Stylesheets, maybe , but format painter at the very least.

I don't mind the group pane view. At least when you click on a group you can be confident you're on the right one. Sometimes when you have nested groups its really hard to find the grouping cell so you can get to its properties. I'm sure this idea comes straight from Crystal's 'group expert'. Another thing you can do is go to the advanced mode in the group pane and set the properties of those other cells. That might actually be the answer your problem with repeating headers / scrolling headers.

VS2010, I'm sure that will come later with Denali, doesn't bother me.

At least with the 2008 R2 BIDS you can target the deploy to a 2008 server.

The most annoying bug is using parameters in queries, where if you change them too much it breaks:
" the expression that references the parameter "param" does not exist in the parameters collection. "

Seems to only happen to me with MDX. Whatever you do, don't rename your parameters or try and add new ones after you depart from visual query mode.

Fair enough that you lose your query if you try and go from text mode back to visual mode, but the text mode parameter editor just doesn't ever seem to add parameters to the 'collection' whatever that is. Maybe I'm doin it wrong.
whimsywhimsy
whimsywhimsy
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 68
Adding report parameters from the UI is missing.
jacquesk
jacquesk
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 Visits: 34
I disagree with the comment about share data sets.


In our company we constantly use the same parameter data sets in almost our reports and creating shared sets ensure consistency between parameters across all of them.



My biggest issue is the differences between 2008 and 2008R2 BI. It seems that each different version has different rdl styles and therefore cross platform support becomes difficult.


Jacques
bhupendra.patel
bhupendra.patel
SSC-Addicted
SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)

Group: General Forum Members
Points: 407 Visits: 235
Hey Andy nice articles both good and bad ones . I would only add to the bad list. They don't allow reports to be localised. You have to jump through so many hoops to get that done.when you can do it so easily in asp.net
AnthonyR
AnthonyR
SSC Veteran
SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)

Group: General Forum Members
Points: 295 Visits: 53
Hey Andy,

Great article, but finished up with:
I particularly like its ease of use and its superb error messages (other Microsoft departments could learn a lot from the SSRS team).


Are you new to SSRS? Smile I'm regularly coming across totally cryptic or deceptive error messages in SSRS 2008 such as the following:
[rsInvalidFilterValueDataType] A filter value in the filter for tablix ‘tabData’ specifies a data type that is not supported by the 'TopN' operator. Verify that the data type for each filter value is Integer.


Although it worked perfectly well in Preview mode in the report designer, this error message appeared when the report was actually deployed. In the end it turned out that the Value field for a Top N expression (in Dataset properties / Filters) I had "20" instead of "=20". Now to me "20" is an integer value and "=20" is an expression - but who am I to argue with the great SSRS team?

Kind regards,
Anthony.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search