Results 1 to 4 of 4

Thread: Ssrs help

  1. #1
    Join Date
    May 2010
    Posts
    52

    Unanswered: Ssrs help

    HELP SSRS..
    Fellow SQL Server users, I am trying to generate a report with that looks like this
    host name cpu memory others ticket_numbers
    12345
    z 0 12 0 45655
    775764
    etc...
    i am generating the results from a simple query that gives me data for every row, but in the report i do not want to repeat the same entry for every row i.e. for host name i just want to display the name (z)once, merge and center it, instead of having 3 entries of the same name. hope i am making sense. how do i achieve this?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    In the SSRS GUI (BIDS or SSDT), right-click and make the host name a "group" item.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    May 2010
    Posts
    52
    thanks Pat, kinda worked, but now i am only getting 1 result for the ticket_numbers instead of 3

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    On the report, left-click the plus sign to the left of the grouped item. Voila!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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