Formatting of Reports

I'm new to reporting services, My company is trying to evaluate the
service to see if we can use it to replace some legacy reports. I'm
able to get most of it done but there is one problem I haven't been
able to solve in the last several days.
Select Table1.columnA, Table1.columnB, Table1.columnC, Table2.columnA,
Table2.columnB
>From Table1 inner join Table2 on Table1.id = Table2.Table1_id
That's giving me the result set I need
AAA AAA AAA BBB BBB
AAA AAA AAA CCC CCC
AAA AAA AAA DDD DDD
The requirement for the report is that data on the report not be
duplicated, so the output should be formatted like
AAA AAA AAA BBB BBB
CCC CCC
DDD DDD
I have tried groups, that seems to do what I want but if I don't have
a header of for the group I'm unable to change it again later, any
advice or direction is appreciated.Hey Lance,
Each cell in your table has a property "Hide Duplicates", so if the
previous field is the same as the current field it doesn't show. You should
simply need to access the property page and then set this field to "True"
Michael C
"lance.sanchez@.gmail.com" wrote:
> I'm new to reporting services, My company is trying to evaluate the
> service to see if we can use it to replace some legacy reports. I'm
> able to get most of it done but there is one problem I haven't been
> able to solve in the last several days.
> Select Table1.columnA, Table1.columnB, Table1.columnC, Table2.columnA,
> Table2.columnB
> >From Table1 inner join Table2 on Table1.id = Table2.Table1_id
> That's giving me the result set I need
> AAA AAA AAA BBB BBB
> AAA AAA AAA CCC CCC
> AAA AAA AAA DDD DDD
> The requirement for the report is that data on the report not be
> duplicated, so the output should be formatted like
> AAA AAA AAA BBB BBB
> CCC CCC
> DDD DDD
> I have tried groups, that seems to do what I want but if I don't have
> a header of for the group I'm unable to change it again later, any
> advice or direction is appreciated.
>|||OK, i can get it to do what I want in the report builder from the
webpage but i cant seem to get the formating to work correctly in SQL
Server Business Intelligence Development Studio. any sugestions?
On Aug 20, 10:45 am, "lance.sanc...@.gmail.com"
<lance.sanc...@.gmail.com> wrote:
> I'm new to reporting services, My company is trying to evaluate the
> service to see if we can use it to replace some legacy reports. I'm
> able to get most of it done but there is one problem I haven't been
> able to solve in the last several days.
> Select Table1.columnA, Table1.columnB, Table1.columnC, Table2.columnA,
> Table2.columnB
> >From Table1 inner join Table2 on Table1.id = Table2.Table1_id
> That's giving me the result set I need
> AAA AAA AAA BBB BBB
> AAA AAA AAA CCC CCC
> AAA AAA AAA DDD DDD
> The requirement for the report is that data on the report not be
> duplicated, so the output should be formatted like
> AAA AAA AAA BBB BBB
> CCC CCC
> DDD DDD
> I have tried groups, that seems to do what I want but if I don't have
> a header of for the group I'm unable to change it again later, any
> advice or direction is appreciated.|||Are you saying when you deploy it to Report Manager it works, but when your
using preview in BID it doesn't? Thats strange...have you tried closing out
the solution, and restarting ti?
"lance.sanchez@.gmail.com" wrote:
> OK, i can get it to do what I want in the report builder from the
> webpage but i cant seem to get the formating to work correctly in SQL
> Server Business Intelligence Development Studio. any sugestions?
>
> On Aug 20, 10:45 am, "lance.sanc...@.gmail.com"
> <lance.sanc...@.gmail.com> wrote:
> > I'm new to reporting services, My company is trying to evaluate the
> > service to see if we can use it to replace some legacy reports. I'm
> > able to get most of it done but there is one problem I haven't been
> > able to solve in the last several days.
> >
> > Select Table1.columnA, Table1.columnB, Table1.columnC, Table2.columnA,
> > Table2.columnB
> >
> > >From Table1 inner join Table2 on Table1.id = Table2.Table1_id
> >
> > That's giving me the result set I need
> >
> > AAA AAA AAA BBB BBB
> > AAA AAA AAA CCC CCC
> > AAA AAA AAA DDD DDD
> >
> > The requirement for the report is that data on the report not be
> > duplicated, so the output should be formatted like
> >
> > AAA AAA AAA BBB BBB
> > CCC CCC
> > DDD DDD
> >
> > I have tried groups, that seems to do what I want but if I don't have
> > a header of for the group I'm unable to change it again later, any
> > advice or direction is appreciated.
>
>