p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports (http://p2p.wrox.com/book-microsoft-sql-server-reporting-services-recipes-designing-expert-reports-562/)
-   -   Dynamic Pivoting as a Matrix Replacement Page 329 (http://p2p.wrox.com/book-microsoft-sql-server-reporting-services-recipes-designing-expert-reports/93888-dynamic-pivoting-matrix-replacement-page-329-a.html)

vchandm23 December 3rd, 2014 02:57 AM

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.


All times are GMT -4. The time now is 12:22 AM.

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