CODEWITHSUNDEEP
sql-server-2005reporting-services
madewulf
madewulf

Reputation: 1910

How to present the result of a dynamic pivot request in SQL Server 2005 Reporting Services?

I have a dynamic pivot request I would like to present in a report of Reporting Services.

As it is dynamic, the number of columns of the result is variable (as is the name of the columns). How could I create a report showing a table handling this variable number of columns ?

Upvotes: 0

Views: 532

Answers (2)

zzawaideh
zzawaideh

Reputation: 2011

You can also use the Matrix control to pivot the results in the report instead of in the query. This way you don't have to use any custom solution.

Upvotes: 1

jgallant
jgallant

Reputation: 11273

You will need to implement a dynamic report definition file. Here is a link that will help you get started. It is a VS Project that dynamically creates a RDLC file with a table, via a datatable. I used it as the base of my current report system.

C# Version

VB.NET Version

If you have any questions about this, let me know. I've been generating RDLC files for quite a while now, and encountered pretty much every issue you could think of :)

Upvotes: 1

Related Questions