How to create Pivot table(Drill in/out) in MS SQL Reporting

#1

Hi All

How can I create cross tab pivot table in MS SQL Reporting Services 2000
with capability of drilling in/out the information as I don't see any direct
control for this
in MS SQL Reporting 2000.

Any help appreciated.
Thanks
Narinder

#2

in Report Server use the matrix object to create a crosstab table.

The new report wizard will create a drillable matrix for you. just follow
the wizard and check the right options.

"narinder" <narinder (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi All

How can I create cross tab pivot table in MS SQL Reporting Services 2000
with capability of drilling in/out the information as I don't see any
direct
control for this
in MS SQL Reporting 2000.

Any help appreciated.
Thanks
Narinder

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to create Pivot table(Drill in/out) in MS SQL Reporting

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

How to create Pivot table(Drill in/out) in MS SQL Reporting - 03-03-2006 , 09:14 AM

Re: How to create Pivot table(Drill in/out) in MS SQL Reporting - 03-03-2006 , 12:17 PM