• My favorite way to do cross-tabs is to cheat..

    Put the data into a cross tab friend format (measures and values to break it out by)

    and feed it into crystal reports.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]