Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Bangalore
    Posts
    28

    Unanswered: Report formatting

    Hi,
    This is a resultset of my stored procedure

    Name Role
    -------------------
    John Admin
    John Supper User
    John Verify
    Robert App User
    Andy Admin

    I would like to present this in the following format using Crystal Reports with VS 2005 Web Application:

    Admin SupperUser Verify Appuser
    ------------------------------------------
    John * * *
    Robert *
    Andy *

    And also in this format:

    Name Role
    --------------
    John Admin
    SupperUser
    Verify
    Robert AppUser
    Andy Admin


    Could some please help me on this.

    Thanks
    C

  2. #2
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    In first case use a crosstab and in second case do grouping on name in your report.
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •