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 document map label using expression

When a report item is hidden, its document map still shows. I would like to
access the hidden attribute of the item (in this case they can be table or
chart, but I believe the model to be the same). I can't seem to find the
object model how to access that attribute. I tried ReportItems!table1.hidden,
ReportItems!table1.visible, ReportItems!table1.Visibility and they all say
those attributes do not belong to the member. Anyone can point me to the doc?
I'll try to dig around and find the dll for reporting services and see if
object browser might help.
Thanks.Hide document map label using expression

Hide [+]/[-] toggle sign when group doesnot have any member

Hi,

I need help to hide [+]/[-] sign when a group doesnot have any item in it. Currently, I have a table with a group header where I put the companyName and in the detail section I put the users for that company. I want that, if a company doesnot have any users then there should not be any [+]/[-] sign next to it. Please help!!

Thanks,

-Rohit

Does any one know the answer to this one?

Thanks.

HelpTotals within Totals

I have a report with say two fields, market, amount. I need a report to present like this, but to do totals after line item presentation...example report looks like this. Question is, how do I do the totals part seperate from the line items??

Market amount
-- --
Texas 10.00
Texas 20.00
Texas 30.00
Boston 10.00
Boston 20.00
Boston 90.00

Totals Texas 60.00
Totals Boston 120.00You can set it up like the following by adding a Group on Market and adding a Running Total Field which Sums Amount to the Group Footer.

Market amount
-- --
Texas 10.00
Texas 20.00
Texas 30.00

Totals Texas 60.00

Boston 10.00
Boston 20.00
Boston 90.00

Totals Boston 120.00

- or -

If you know what Market is going to be, you can set up Formula Fields with the following Formula:

NumberVar intTotal
IF {Market} = 'Texas' THEN
NumberVar := NumberVar + {Amount}

- or -

There's a Formula that looks like: Sum(fld, condFld, cond). I have never used it, but I assume you can set it up simialr to:

Sum ( {Amount}, {Market}, 'Texas' )

(I didn't test this code, so you may have to tweak it a bit to work out any bugs.)|||Thanks malleyo but there's a subtle difference in the report...the footer has and entries for each market. The list of markets is dynamic (a group by field)...thus, option 1 and 2-3 aren't quite it...I have a feeling I have to use subreports.

Let me know if you have any other thoughts and thanks for your help.|||Hi Mallego
How to sum amount large than 10 ?|||ReportDude,
I guess you are right there is no option otherthan subreport, I had the same issue before and I used sub report.
But if you find better solution other than SubReport please post the solution.

Thanks,
Gragi