Post reply

Multiple fields in the group

  • September 14, 2016 at 10:08 am

    #321469

    My report has the following fields, AccountNumber, Name, Birthdate, surgical procedure, surgery date. AccountNumber, Name, BirthDate are unique to each record but, some records may have more than one surgical procedure and date so, the unique values duplicate. How can I get the report to display the AccountNumber, Name, Birthdate only once but, show the multiple procedures and dates?

    I'm using Visual Studio.

  • September 14, 2016 at 10:33 am

    #1900906

    In Visual Studio:

    1. Create an SSRS table with columns for surgical procedure & surgery date.

    2. Click on that table then, under Row Groups, right-click on the "=(details)" group and select Add Group > Parent Group

    3. In the Group by drop-down select AccountNumber and click OK.

    4. Now you'll see a new group named "AccountNumber"... Right-click your new group and go to properties

    5. In the Group Expressions click Add, and add Name and BirthDate... Now it should say "Group on: [AccountNumber] and on [name] and on [BirthDate]. Click ok.

    6. On your table there's a column for AccountNumber. Right-Click that column and select "Insert Column" > "Inside Group - Right", then add Name. Do the same thing for Birthdate.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • September 14, 2016 at 11:22 am

    #1900916

    Perfect. Thanx.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply