don't show blank spaces caused by hidden duplicates in detail row.

I'm trying to solve on how to remove the blank row spaces in a table that is caused by hide duplicates. I have a lot of this record duplicate and it is hidden, but it display a very long blank spaces of rows before getting to the next group. Is there a way not to print the hidden row?Advance Thanks to the one giving the answers... :)
"Dzus" wrote:
> I'm trying to solve on how to remove the blank row spaces in a table that is caused by hide duplicates. I have a lot of this record duplicate and it is hidden, but it display a very long blank spaces of rows before getting to the next group. Is there a way not to print the hidden row?
>|||Hi Dzus,
For a whole row to be 'removed' in this way, I believe the 'hide duplicates' value must be true for every cell in the row.
Regards
Chris
"Dzus" wrote:
> Advance Thanks to the one giving the answers... :)
> "Dzus" wrote:
> > I'm trying to solve on how to remove the blank row spaces in a table that is caused by hide duplicates. I have a lot of this record duplicate and it is hidden, but it display a very long blank spaces of rows before getting to the next group. Is there a way not to print the hidden row?
> >
> >|||Hi Chris...
That was pretty fast response and thanks... But the problem still exists. I have already 'hide duplicates' on every cells on the same row that you've instructed, and it still show the blank rows...Hmmm...
This record that i've "hide duplicates" for every cells in the same row belongs to the detail grouping. Did i miss anything in editing the visibility properties under the details grouping?
Thanks again...,
Dzus
"Chris McGuigan" wrote:
> Hi Dzus,
> For a whole row to be 'removed' in this way, I believe the 'hide duplicates' value must be true for every cell in the row.
> Regards
> Chris
> "Dzus" wrote:
> > Advance Thanks to the one giving the answers... :)
> >
> > "Dzus" wrote:
> >
> > > I'm trying to solve on how to remove the blank row spaces in a table that is caused by hide duplicates. I have a lot of this record duplicate and it is hidden, but it display a very long blank spaces of rows before getting to the next group. Is there a way not to print the hidden row?
> > >
> > >|||You can simply delete the row from the table. Or, you can set the row
visibility to false.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dzus" <Dzus@.discussions.microsoft.com> wrote in message
news:7F901BAE-9054-4650-8574-3F7F3227479A@.microsoft.com...
> I'm trying to solve on how to remove the blank row spaces in a table that
> is caused by hide duplicates. I have a lot of this record duplicate and it
> is hidden, but it display a very long blank spaces of rows before getting
> to the next group. Is there a way not to print the hidden row?
>|||Hi Brian
Thanks for the reply.
But if i delete or set the row visibility to false, then all the 1st instance of the values i have for that particular row will not be displayed.
Actually i need the 1st instance of a value to be displayed and the duplicate ones not to be shown. I have set the properties to 'hide duplicates' for all the available fields in that particular row, and the thing is it managed to hide but it print out as a blank row before printing the next available record. Can i removed this blank row?
Thanks.
"Brian Welcker [MSFT]" wrote:
> You can simply delete the row from the table. Or, you can set the row
> visibility to false.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Dzus" <Dzus@.discussions.microsoft.com> wrote in message
> news:7F901BAE-9054-4650-8574-3F7F3227479A@.microsoft.com...
> > I'm trying to solve on how to remove the blank row spaces in a table that
> > is caused by hide duplicates. I have a lot of this record duplicate and it
> > is hidden, but it display a very long blank spaces of rows before getting
> > to the next group. Is there a way not to print the hidden row?
> >
> >
>
>|||If you are setting hide duplicates on every single field, then you are
creating a group. You should create a group instead and delete the detail
row.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dzus" <Dzus@.discussions.microsoft.com> wrote in message
news:65D6F017-225C-4671-8957-F09815A34AAD@.microsoft.com...
> Hi Brian
> Thanks for the reply.
> But if i delete or set the row visibility to false, then all the 1st
> instance of the values i have for that particular row will not be
> displayed.
> Actually i need the 1st instance of a value to be displayed and the
> duplicate ones not to be shown. I have set the properties to 'hide
> duplicates' for all the available fields in that particular row, and the
> thing is it managed to hide but it print out as a blank row before
> printing the next available record. Can i removed this blank row?
> Thanks.
> "Brian Welcker [MSFT]" wrote:
>> You can simply delete the row from the table. Or, you can set the row
>> visibility to false.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Dzus" <Dzus@.discussions.microsoft.com> wrote in message
>> news:7F901BAE-9054-4650-8574-3F7F3227479A@.microsoft.com...
>> > I'm trying to solve on how to remove the blank row spaces in a table
>> > that
>> > is caused by hide duplicates. I have a lot of this record duplicate and
>> > it
>> > is hidden, but it display a very long blank spaces of rows before
>> > getting
>> > to the next group. Is there a way not to print the hidden row?
>> >
>> >
>>|||Oh yes...! Thanx a lot Brian... Maybe now i'm more understand between the group and the details...
"Brian Welcker [MSFT]" wrote:
> If you are setting hide duplicates on every single field, then you are
> creating a group. You should create a group instead and delete the detail
> row.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Dzus" <Dzus@.discussions.microsoft.com> wrote in message
> news:65D6F017-225C-4671-8957-F09815A34AAD@.microsoft.com...
> > Hi Brian
> >
> > Thanks for the reply.
> >
> > But if i delete or set the row visibility to false, then all the 1st
> > instance of the values i have for that particular row will not be
> > displayed.
> >
> > Actually i need the 1st instance of a value to be displayed and the
> > duplicate ones not to be shown. I have set the properties to 'hide
> > duplicates' for all the available fields in that particular row, and the
> > thing is it managed to hide but it print out as a blank row before
> > printing the next available record. Can i removed this blank row?
> >
> > Thanks.
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> You can simply delete the row from the table. Or, you can set the row
> >> visibility to false.
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "Dzus" <Dzus@.discussions.microsoft.com> wrote in message
> >> news:7F901BAE-9054-4650-8574-3F7F3227479A@.microsoft.com...
> >> > I'm trying to solve on how to remove the blank row spaces in a table
> >> > that
> >> > is caused by hide duplicates. I have a lot of this record duplicate and
> >> > it
> >> > is hidden, but it display a very long blank spaces of rows before
> >> > getting
> >> > to the next group. Is there a way not to print the hidden row?
> >> >
> >> >
> >>
> >>
> >>
>
>