hide duplicates.. another pdf bug?

I'm getting different views where I run the report from the Report Manager
and then after its exported to pdf. The results are the same when the report
is viewed from the Preview Mode in the Report Deisigner.
The Report has 3 groupings on data and I'm hiding some column values using
"Hide Duplicates". As menioned above, the "hide duplicates" functionality
works well in the Report Designer & Report Manager before exporting to pdf.
Is this a bug in the export functionality? How do I take care of this
discrepancy?
ThanksWhat is more exactlly the discrepancy? Are the textboxes still visible in
pdf? Could you send us the report and data to repro, please?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"newmem" <""> wrote in message news:u9OR7jTXEHA.3640@.TK2MSFTNGP11.phx.gbl...
> I'm getting different views where I run the report from the Report Manager
> and then after its exported to pdf. The results are the same when the
report
> is viewed from the Preview Mode in the Report Deisigner.
> The Report has 3 groupings on data and I'm hiding some column values using
> "Hide Duplicates". As menioned above, the "hide duplicates" functionality
> works well in the Report Designer & Report Manager before exporting to
pdf.
> Is this a bug in the export functionality? How do I take care of this
> discrepancy?
> Thanks
>

Hide Duplicates help needed

I have a report with 3 cols. All 3 cols have hide duplicates checked.
Here is hat I currently get:
AAA BBB CCC
DDD
BBB
FFF FFF FFF
Here is what I would like to see:
AAA BBB CCC
DDD CCC
BBB DDD CCC
FFF FFF FFF
If something to the left changes the values to the right of the col will
print.
If anybody has any ideas they would be greatly appreciated.
Thank You
JohnI may be missing something but it appears you only want to hide
duplicates in the first column and show the duplicates in the second
and third columns. So instead of hiding duplicates for all three
columns, just hide duplicates for the first column.
John A Kushwarra wrote:
> I have a report with 3 cols. All 3 cols have hide duplicates checked.
> Here is hat I currently get:
> AAA BBB CCC
> DDD
> BBB
> FFF FFF FFF
>
> Here is what I would like to see:
> AAA BBB CCC
> DDD CCC
> BBB DDD CCC
> FFF FFF FFF
>
> If something to the left changes the values to the right of the col will
> print.
> If anybody has any ideas they would be greatly appreciated.
> Thank You
> Johnsql

Hide Duplicates Attribute Not working

We are creating a matrix report with multiple row headers. There are
duplicate values in the first column. The duplicate values are hidden but we
would like them to be displayed. The â'HideDuplicatesâ' attribute is
unchecked. Ultimately, this report will be exported to Excel and we will be
using these column values to filter the data so I need values in every column
for every row. Is there another attribute that we are missing?
Thanks,
TylerHi Tyler
Did you find a solution to this problem? We have the exact same requirement
- need to output a matrix report to Excel with all cells showing.
Thanks
"Tyler Allbritton" wrote:
> We are creating a matrix report with multiple row headers. There are
> duplicate values in the first column. The duplicate values are hidden but we
> would like them to be displayed. The â'HideDuplicatesâ' attribute is
> unchecked. Ultimately, this report will be exported to Excel and we will be
> using these column values to filter the data so I need values in every column
> for every row. Is there another attribute that we are missing?
> Thanks,
> Tyler|||No - I'm an MSDN subscriber, so I expected a response from MS, but nothing.
"Phil Jeffrey" wrote:
> Hi Tyler
> Did you find a solution to this problem? We have the exact same requirement
> - need to output a matrix report to Excel with all cells showing.
> Thanks
>
> "Tyler Allbritton" wrote:
> > We are creating a matrix report with multiple row headers. There are
> > duplicate values in the first column. The duplicate values are hidden but we
> > would like them to be displayed. The â'HideDuplicatesâ' attribute is
> > unchecked. Ultimately, this report will be exported to Excel and we will be
> > using these column values to filter the data so I need values in every column
> > for every row. Is there another attribute that we are missing?
> >
> > Thanks,
> > Tyler

Hide Duplicates - and border

If a person selects the "hide duplicates" option in a Table/Group, how would
one also hide the "border"?
I've tried using expressions to set the borderstyle to None, and this works,
but I can't figure out how to evaluate if a table cell (value) is "hidden".
Below is what I'm trying to do, hide the border, if the (duplicating) value
is hidden.
Division Product 1999 2000 2001 2002
North Wiget 100 200 100 300
Racket 100 200 100 300
Doget 100 200 100 300
South Wiget 100 200 100 300
Racket 100 200 100 300
Doget 100 200 100 300
East Wiget 100 200 100 300
Racket 100 200 100 300
Doget 100 200 100 300
West Wiget 100 200 100 300
Racket 100 200 100 300
Doget 100 200 100 300
Thx,
RussellHaven't tried it but you should be able to use a conditional border based on
the Previous() aggregate.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
news:uN%23WlOexEHA.2036@.TK2MSFTNGP12.phx.gbl...
> Sorry, but my example did not come across as I sent it.
> I've attached a jpg as an example...
> Thx,
> Russell
>
> "Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
> news:eWFwWGexEHA.2036@.TK2MSFTNGP12.phx.gbl...
>> If a person selects the "hide duplicates" option in a Table/Group, how
>> would
>> one also hide the "border"?
>> I've tried using expressions to set the borderstyle to None, and this
>> works,
>> but I can't figure out how to evaluate if a table cell (value) is
>> "hidden".
>> Below is what I'm trying to do, hide the border, if the (duplicating)
>> value
>> is hidden.
>> Division Product 1999 2000 2001 2002
>> North Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> South Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> East Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> West Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>>
>> Thx,
>> Russell
>>
>|||Thanks Brian,
That is my issue. I have been trying to do a conditional border, but I can't
figure out what the "expression" is that I need to use to evaluate to True.
If I test the textbox (in the table) for Value="" it returns a False. I
assume that the textbox still has a value, it's Visibility is just hidden.
So what I can't figure out is the expression to use to test a textbox's
"Visibility" (if this is the correct approach).
Thanks,
Russell
"Brian Welcker [MS]" <bwelcker@.online.microsoft.com> wrote in message
news:%23Hz3i$ixEHA.1260@.TK2MSFTNGP12.phx.gbl...
> Haven't tried it but you should be able to use a conditional border based
> on the Previous() aggregate.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
> news:uN%23WlOexEHA.2036@.TK2MSFTNGP12.phx.gbl...
>> Sorry, but my example did not come across as I sent it.
>> I've attached a jpg as an example...
>> Thx,
>> Russell
>>
>> "Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
>> news:eWFwWGexEHA.2036@.TK2MSFTNGP12.phx.gbl...
>> If a person selects the "hide duplicates" option in a Table/Group, how
>> would
>> one also hide the "border"?
>> I've tried using expressions to set the borderstyle to None, and this
>> works,
>> but I can't figure out how to evaluate if a table cell (value) is
>> "hidden".
>> Below is what I'm trying to do, hide the border, if the (duplicating)
>> value
>> is hidden.
>> Division Product 1999 2000 2001 2002
>> North Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> South Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> East Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>> West Wiget 100 200 100 300
>> Racket 100 200 100 300
>> Doget 100 200 100 300
>>
>> Thx,
>> Russell
>>
>>
>

Hide Duplicates

I trying to create a report that looks like this:

Item Shipped OnHand PO# DueDate POQty

1234 0 0 111 8/01/07 12

222 8/08/07 12

333 8/16/07 12

2345 4 0 444 8/04/07 24

I pull back all the data in a single query and the result looks like this...

Item Shipped OnHand PO# DueDate POQty

1234 0 0 111 8/01/07 12

1234 0 0 222 8/08/07 12

1234 0 0 333 8/16/07 12

2345 4 0 444 8/04/07 24

Now I can use the Hide Duplicates property to fix the Item column since the query groups on item guaranteeing uniqueness. But that won't work for the Shipped and OnHand columns because adjacent items may have the same Shipped and OnHand totals. How do I hide the Shipped and OnHand values if and only if the Item is the same? Is this really a problem of hiding duplicates or do I need to break apart my query or find a sub-reporting solution?

Hi jimdt

You can Hide Shipped and OnHand Values
In the Visibility Property of the Shipped and OnHand Write the Following Expression

=IIF(Previous(Fields!Item.Value) = Fields!Item.Value AND Previous(Fields!Shipped.Value) = Fields!Shipped.Value AND Previous(Fields!OnHand.Value) = Fields!OnHand.Value, True, False)

|||

Hi,

use a table and build a group based on item and use the field item from your dataset in the group header.

If your dataset brings "shipped" and "OnHand" per item and you are allowed to build a sum do a sum(Shipped) in the group header, if summing brings up wrong values because sum is not allowed because the measures are allready sums use max(shipped) as a workaround.

cheers,
Markus

Hide Duplicates

When you hide duplicates on the report, is there any way to reclaim the space
that the duplicate is taking. I am seeing extra spaces between the rows on my
reports. I would like the rows with data to be next to each other without the
extra white space.Consider making it a group heading of the same group. Then it should only
display onse and not hold the space as a detail row would. I had the same
issue just yesterday.
Hope this helps.
"MAGrimsley" wrote:
> When you hide duplicates on the report, is there any way to reclaim the space
> that the duplicate is taking. I am seeing extra spaces between the rows on my
> reports. I would like the rows with data to be next to each other without the
> extra white space.|||Thanks that took care of the detail row, any thoughts on the white space
between groups?
"Michael Montgomery" wrote:
> Consider making it a group heading of the same group. Then it should only
> display onse and not hold the space as a detail row would. I had the same
> issue just yesterday.
> Hope this helps.
> "MAGrimsley" wrote:
> > When you hide duplicates on the report, is there any way to reclaim the space
> > that the duplicate is taking. I am seeing extra spaces between the rows on my
> > reports. I would like the rows with data to be next to each other without the
> > extra white space.|||Yes. I think.
Make sure they are the same group number. You can have multiple headers of
the same group.
"MAGrimsley" wrote:
> Thanks that took care of the detail row, any thoughts on the white space
> between groups?
> "Michael Montgomery" wrote:
> > Consider making it a group heading of the same group. Then it should only
> > display onse and not hold the space as a detail row would. I had the same
> > issue just yesterday.
> >
> > Hope this helps.
> >
> > "MAGrimsley" wrote:
> >
> > > When you hide duplicates on the report, is there any way to reclaim the space
> > > that the duplicate is taking. I am seeing extra spaces between the rows on my
> > > reports. I would like the rows with data to be next to each other without the
> > > extra white space.

Hide Duplicates

I have a query returning a parent table with mutliple child rows. I want the
report to show the info from the parent table and then show all the child
info and then show the next parent info. Setting the parent fields to Hide
Duplicates prints the information the right way, but leaves a blank area
where those fields would have printed. Then below it prints the child table
fields. How can I make it skip the repeated values entirely?Group the table with the Unique Parent field and display the parent info in
group header and child fields in the details part.
"MNicks" wrote:
> I have a query returning a parent table with mutliple child rows. I want the
> report to show the info from the parent table and then show all the child
> info and then show the next parent info. Setting the parent fields to Hide
> Duplicates prints the information the right way, but leaves a blank area
> where those fields would have printed. Then below it prints the child table
> fields. How can I make it skip the repeated values entirely?sql