p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 (http://p2p.wrox.com/forumdisplay.php?f=251)
-   -   Dynamic number of columns returned from sp (http://p2p.wrox.com/showthread.php?t=44845)

dreadjr July 5th, 2006 12:06 PM

Dynamic number of columns returned from sp
 
I am creating a report which calls a stored procedure. This stored procedure is cross tabular and returns an undetermined amount of columns back in the dataset. Is there a way to auto generated the columns in Reporting Services 2005. I want something that will work like a grid object, which dynamically's generates the columns in the dataset. thanks..


dduvarney July 5th, 2006 03:42 PM

Reporting Services can't dynamically shift with a dataset that has changing columns as you have described.

However, you can use the matrix to get the same affect. First, you need to have a query that passes back a set dataset instead of a dynamic one. For Example, if you are putting months across your columns, make each month its own row (and a single column) instead. This will flatten the dataset for Reporting Services. Then use the Matrix control to get your cross tab affect. The Matrix will group by each individual month.



All times are GMT -4. The time now is 06:15 PM.

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