SSRS 2005 - Report Builder - Grouping

  • Whenever the first field on the report is defined in the Report Model with

    DiscourageGrouping = False, it creates a group even though I want it

    displayed with the rest of the data. When DiscourageGrouping = True, the

    field will not, by default, create it's own group when it is the first field

    on the report.

    For example, suppose I have 4 fields in my Report Model (AccountName, State,

    City, Zip). I have AccountName and State defined as DiscourageGrouping =

    False b/c the users may want to group on these fields sometimes, but not all

    the time (when I set DiscourageGrouping = True, it looks like I can never

    group on the field).

    When a report creator, uses Report Builder to

    create a report and drops AccountName on the report first, it creates a group

    for AccountName. When the user adds fields to the right of the AccountName

    field, the fields are in a separate group. If the user just wants a listing

    of all Accounts with their addresses, with no Groupings, and they want

    AccountName as the first field in the group, how is this possible?

  • I am having this same issue. Does anyone have a solution?

    Thanks. Julie

  • In Report model set DiscourageGrouping=false on all the attributes in the model. Now this will solve this problem.

    Regards,

    Raju Malla

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

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