Report Builder grouping?

Hello,
I am experiencing some funky (yes, that is a technical term) behavior with
SSRS 2005 Report Builder. I have a model setup with some of the fields set
to have their DiscourageGrouping property equal to True and some with it to
False. It seems that only SOMETIMES, when I add the fields with the
DiscourageGrouping set to TRUE to the report it wants to create a new group
for me.
I understand that this is the behavior when you add the columns to the left
of the other fields on the report (I think that the documentation refers to
this as a Value Group). BUT this is happending when I add the field as the
first item on the report. Each subsequent field I add to the left on the
report is inserted to another "main" group...
One note about my Report Model. It was created off a SQL View, not a bunch
of tables (tables probably being the more widely used situation).
Any idea what might be causing this strange behavior?
Anywhere I can go for more information on Report Builder usage? I haven't
found a whole lot of documentation on the usage of the product out there
(other than what is in BOL).
Thanks!
-BrianOK...I know what it is doing to me...but I don't know if it is a bug or if it
was intended to act this way...
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 3 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, using Report Builder (not Repot Designer!!), 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'
Thanks!
-Brian
"brianpmccullough" wrote:
> Hello,
> I am experiencing some funky (yes, that is a technical term) behavior with
> SSRS 2005 Report Builder. I have a model setup with some of the fields set
> to have their DiscourageGrouping property equal to True and some with it to
> False. It seems that only SOMETIMES, when I add the fields with the
> DiscourageGrouping set to TRUE to the report it wants to create a new group
> for me.
> I understand that this is the behavior when you add the columns to the left
> of the other fields on the report (I think that the documentation refers to
> this as a Value Group). BUT this is happending when I add the field as the
> first item on the report. Each subsequent field I add to the left on the
> report is inserted to another "main" group...
> One note about my Report Model. It was created off a SQL View, not a bunch
> of tables (tables probably being the more widely used situation).
> Any idea what might be causing this strange behavior?
> Anywhere I can go for more information on Report Builder usage? I haven't
> found a whole lot of documentation on the usage of the product out there
> (other than what is in BOL).
> Thanks!
> -Brian