SSRS 2005 - Report Builder - Grouping

  • Is there a way to add fields that have the DiscourageGrouping property set to False to a report in Report Builder without them grouping?

    I tried adding the entity rather than individual fields and that prevents the grouping, but the results are not correct when I do this.

    Example:

    I have a field called 'Customer' and a field called 'Contact'.

    A Customer can have many Contacts.

    When the user builds a report in Report Builder, they might not always want to group on Customer.

    If you add the Customer field and then the Contact field, the report groups by Customer.

    If I add the entity to the report, it will not group, but it will only show one Contact per Customer.

    So if a Customer has 3 Contacts, I should get 3 lines, but I only get one.

    Any ideas?

  • you can add group by contact it will display the 3 record or delete the existing group.

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

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