Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports
This is the forum to discuss the Wrox book Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports by Paul Turley, Robert M. Bruckner; ISBN: 9780470563113
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports 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 May 7th, 2011, 04:08 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: May 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Question Error msg on Synchronizing inner matrix groups

After having built tablix described under Synchronizing Groups, Charts and Sparklines (p. 229+), I receive the following error when trying to preview report after completing step #7 (Synchronize inner matrix groups):

System.Web.Services.Protocols.SoapException: The detail grouping 'Sparkline1_CategoryGroup' in the chart 'Sparkline1' has DomainScope 'SalesAnalysisTablix'. Domain scope is only allowed for non detail groups.

Have built recipe carefully; SSRS 2008R2. Everything is okay through step #6, but I miss the whole intent of the exercise by not being able to successfully complete step #7.

Tablix is named SalesAnalysisTablix as instructed, which is exactly what I enter in Group.DomainScope property.

Suggestions? Solution? Thanks!
Reply With Quote
  #2 (permalink)  
Old May 9th, 2011, 12:22 AM
Registered User
Points: 18, Level: 1
Points: 18, Level: 1 Points: 18, Level: 1 Points: 18, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2010
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello chornung,

based on the error message you provided, you were missing step 4d.
Make sure that you edit the group expression of the sparkline chart, and set it explicitly as specified in the step as: =Fields!OrderYear.Value & Fields!OrderQtr.Value

Btw, note that you can also download and inspect the final report from this recipe here: http://media.wiley.com/product_ancil...Sparklines.zip

HTH,
Robert
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
error msg almotions ASP.NET 2.0 Basics 3 February 12th, 2008 07:34 AM
Error msg 3021 MathLearner VB Databases Basics 1 May 17th, 2007 07:41 AM
error msg aspsuraj BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 1 November 27th, 2006 07:30 PM
2 independent Column Groups in report matrix? Andrei Reporting Services 1 February 20th, 2006 11:42 PM
Breakpoint Error Msg Louisa VB.NET 2002/2003 Basics 1 March 29th, 2004 05:42 AM



All times are GMT -4. The time now is 04:59 PM.


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