Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Another Way to Hide Duplicates in RS

    Hi I have two groups one is the state category the other is the state services. and I am trying to hide the duplicates for the state category

    looks like this.


    Selft Concept
    Culture

    Self Concept
    Youth leadership

    Academic Support
    Large Group


    I only need the State Categories to show up one time not every time there is a State services that relates to it, (hope that makes sense) when I went to the properties to hide the duplicates it didnt work. Is there another way to do that??

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    As a great man once said: Huh ?!?!?

    You know too much about your subject to explain it simply for us mere mortals. Which of the above are what?

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

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    if yiou look at the attachment that I exported from RS to Excel you will see that per record there is either Self Concept or Academic Support, I am trying to make it so that they show once per record. I keep getting duplicates. I am trying to get it to look like the attachement on book1. But I keep getting the Academic Support and the Selfconcept and the Counseling (which is [State Category] to once show per record more then once and I dont need duplicates. I am tryign to get it to look like the detail section of Book1 and its not working if you look at the StateReport thats what I got. I have the table grouped by [State Category], StudentID, and [State Services]


    Code:
    SELECT     [Student Activity_ind].[Activity Date], [Student Activity_ind].[Total Time], Student_ind.[Studentschool Id], Student_ind.schoolID, 
                          Student_ind.[Student First Name], Student_ind.[Student Last Name], [Student Activity_ind].[State Services], [Student Activity_ind].[State Category], 
                          [Student Activity_ind].[Primary Catagory], [Student Activity_ind].Activity, [Student Activity_ind].Services, [Student Activity_ind].[Covered during Session], 
                          Student_ind.[Student ID]
    FROM         Student_ind INNER JOIN
                          [Student Activity_ind] ON Student_ind.[Student ID] = [Student Activity_ind].[Student ID]
    WHERE     ([Student Activity_ind].[Activity Date] BETWEEN @Beginning_ActivityDate AND @End_ActivityDate) AND (Student_ind.[Studentschool Id] IS NOT NULL) 
                          AND (Student_ind.schoolID IS NOT NULL)
    Attached Files Attached Files
    Last edited by desireemm; 07-06-09 at 06:32.

Posting Permissions

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