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 December 3rd, 2014, 02:57 AM
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2014
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Dynamic Pivoting as a Matrix Replacement Page 329

Hi Guru(s),
First of all this book is awesome and RESPECT TO ALL THE AUTHORS WHO HAVE SHARED THEIR KNOWLEDGE.

When creating the dataset using the Store Procedure that has the Dynamic Pivot query, my dataset is not populating the values. Can you elaborate this step for me.

EXACT PORTION THAT I HAVE PROBLEM.

PAGE 329:

2. Create a new dataset in the report titled ResellerSalesPivot with AdventureWorksDW as the
data source. Choose the Stored Procedure radio button and enter the usp_Sales_by_
Territory_Dynamic_Pivot stored procedure above in the entry line. Navigate to the
Parameters menu in the left-hand navigation bar and when prompted type the values 587 for
@productID, Europe for @territory, and 2003-07-01 for @startMonth. This step is necessary
in order for field metadata to be populated.

This book is 'the bomb'!!

Thanks.
vchandm23.
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
Need faster pivoting XSLT keith h nicholsen XSLT 4 May 10th, 2009 07:58 PM
Dynamic replacement of attribute value Satyajit Sahu XSLT 3 July 13th, 2007 01:54 PM
ASP.NET - Static Page and Dynamic Page sohrabus ASP.NET 2.0 Professional 2 April 19th, 2007 12:42 AM
Page headers with Subreport and Matrix control runlevel007 BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 April 20th, 2005 05:16 PM
Dynamic Matrix Spaceskapie Classic ASP Professional 1 October 15th, 2004 09:05 AM



All times are GMT -4. The time now is 01:28 AM.


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