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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:324E44CB-8340-4339-8C63-32E1CFE4A788@xxxxxxxxxxxxxxxx
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



.



Relevant Pages

  • RE: Access report
    ... No sure fire way of knowing exactly what the Report Wizard ... | Subject: RE: Access report ... Produced By Microsoft MimeOLE V5.50.4910.0300 ...
    (microsoft.public.access.security)
  • Error instantiating cursor object
    ... report wizard, clears the filter, releases form1 and calls form2. ... SET FILTER TO prn=.T. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Generating/Invoking "Report Wizard"
    ... But i am not able to give Title Name.I want to replace the "Report Wizard" ... > DoCmd.RunCommand acCmdNewObjectReport ... You could code around this and the full sub ...
    (microsoft.public.access.formscoding)
  • Re: Generating/Invoking "Report Wizard"
    ... But i am not able to give Title Name.I want to replace the "Report Wizard" ... > DoCmd.RunCommand acCmdNewObjectReport ... You could code around this and the full sub ...
    (microsoft.public.access.forms)
  • Re: Generating/Invoking "Report Wizard"
    ... But i am not able to give Title Name.I want to replace the "Report Wizard" ... > DoCmd.RunCommand acCmdNewObjectReport ... You could code around this and the full sub ...
    (microsoft.public.access.reports)