Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2008 > BOOK: Professional Microsoft SQL Server 2008 Reporting Services ISBN: 978-0-470-24201-8
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional Microsoft SQL Server 2008 Reporting Services ISBN: 978-0-470-24201-8
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2008 Reporting Services by Paul Turley, Thiago Silva, Bryan C. Smith, Ken Withee; ISBN: 9780470242018
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft SQL Server 2008 Reporting Services ISBN: 978-0-470-24201-8 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old November 23rd, 2011, 04:31 PM
Registered User
Points: 11, Level: 1
Points: 11, Level: 1 Points: 11, Level: 1 Points: 11, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2011
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default SSRS SQL 2008 R2 - An unexpected error occurred in Report Processing

I recently upgraded to SQL 2008 R2 and I have created a new report in BIDS. I can preview this new report and everything works and looks great, however when I try to deploy this report I get the error message of "An Unexpected Error Occurred In Report Processing". It may be worth mentioning my report uses multiple parameters. I have narrowed down the problem to a few pie charts that I have included. When I remove the pie charts the report deploys perfectly.

Additionally, I tried creating a totally new report with a single pie chart, removed all parameters and tried to deploy it as well, with no luck.

Does anyone know if there is a know issue with deploying pie charts in SSRS 2008?

Thanks in advance

Rich
Reply With Quote
  #2 (permalink)  
Old November 23rd, 2011, 04:50 PM
Wrox Author
Points: 180, Level: 3
Points: 180, Level: 3 Points: 180, Level: 3 Points: 180, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2004
Location: Vancouver, Washington, USA.
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There is certainly not a general problem with pie charts or any other type of charts in SSRS 2008 or SSRS 2008 R2. Many companies are using these and other features in thousands of production deployments.
Check the version compatibility property for your report project and make sure it matches the version of your target server. If this isn't the issue, I suspect a component registration problem of some kind.
Does the problem occur if you upload the RDL file directly in Report Manager or SharePoint?
I recommend that you uninstall/reinstall Reporting Services on the server or test with an alternate server.
__________________
Paul Turley
Mentor | SQL Server MVP, SolidQ
Blog: sqlserverbiblog.com
Author: SQL Server Reporting Services Recipes for Designing Expert Reports; Professional SQL Server Reporting Services (2000, 2005, 2008 & 2012), Beginning T-SQL (2000, 2005 & 2008), SSIS, SSAS & Access
Reply With Quote
  #3 (permalink)  
Old November 23rd, 2011, 05:00 PM
Registered User
Points: 11, Level: 1
Points: 11, Level: 1 Points: 11, Level: 1 Points: 11, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2011
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the response Paul. I will look into the version and registration potential issues you mentioned. Additionally, I get the same error message when I try to upload the file directly into Report Manager.

I found a similar occurrence in a technet forum thread (that I also posted to earlier today).

http://social.technet.microsoft.com/...8-5ea44769d592

Thanks again for taking the time and I will try your suggestions.

Rich
Reply With Quote
  #4 (permalink)  
Old November 24th, 2011, 08:46 AM
Registered User
Points: 11, Level: 1
Points: 11, Level: 1 Points: 11, Level: 1 Points: 11, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2011
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

A quick update;

I right clicked on the 'Details' under the Category Group properties for the pie chart and deleted the category group and this seems to have fixed my deployment issue.

Thanks again

Rich
Reply With Quote
  #5 (permalink)  
Old November 29th, 2011, 03:23 PM
Wrox Author
Points: 180, Level: 3
Points: 180, Level: 3 Points: 180, Level: 3 Points: 180, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2004
Location: Vancouver, Washington, USA.
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is certainly not very helpful error feedback. If you are able to reproduce this behavior in a current product verison, please post a bug/feedback for the SSRS product team at Connect.Microsoft.com.

Thanks for letting me know what you found.
__________________
Paul Turley
Mentor | SQL Server MVP, SolidQ
Blog: sqlserverbiblog.com
Author: SQL Server Reporting Services Recipes for Designing Expert Reports; Professional SQL Server Reporting Services (2000, 2005, 2008 & 2012), Beginning T-SQL (2000, 2005 & 2008), SSIS, SSAS & Access
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
SSRS 2008 R2 Export to Word (Image Issue) Narendra.Patil Reporting Services 0 November 15th, 2011 12:19 PM
Need Help with Classic ASP on Window Server 2008 R2 Nishapd Classic ASP Basics 0 November 7th, 2011 11:50 AM
Can I host SQl 2008 R2 database in SQL 2005 Server? anantgupta ASP.NET 4 General Discussion 0 July 2nd, 2011 02:43 AM
Book Samples available for RDS 2008 R2 TrevorTaylor BOOK: Professional Microsoft Robotics Studio ISBN: 978-0-470-14107-6 0 July 13th, 2009 04:06 AM
unexpected error has occurred tworkman BOOK: ASP.NET Website Programming Problem-Design-Solution 20 July 1st, 2007 09:49 PM



All times are GMT -4. The time now is 01:37 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.