all groups > sql server reporting services > may 2007 >
You're in the

sql server reporting services

group:

display data without auto grouping in report builder


display data without auto grouping in report builder Daisy
5/16/2007 1:08:02 PM
sql server reporting services: I have a report built by report builder. When I run report several column
data did not show repeated data on each row. Instead it just show one time
and the other repeated data field just auto merged with the first cell. Is
there any way to show each row data no matter it is the same as the one in
the cell above?

Example now I see:

Type City State
HSLA PHILADELPHIA PA
NORCROSS GA
PAOLI PA
PAOLI PA

What I want to get is:
HSLA PHILADELPHIA PA
HSLA NORCROSS GA
HSLA PAOLI PA
HSLA PAOLI PA

Is it possible to do that in "design report" or after hit "Run Report"? I
don't want the auto grouping in adhoc report. Please HELP! I really
appreciate it.
RE: display data without auto grouping in report builder Daisy
5/16/2007 1:59:02 PM
I figured it out. The column is shown in the group if you click 'sort and
group'. Just drag all the fields you want and drop them on the table so that
the group is created in entity name instead of the individual field names.

[quoted text, click to view]
AddThis Social Bookmark Button