January 9, 2012 at 11:09 am
I would like my report to look something like this:
part# UOM Desc Qty UnitPrice
4567 EA washer02 1 0.45
3947 EA washer01 3 0.33
2987 EA box34 2 0.22
EA tape01 1 1.44
EA liner05 3 0.87
EA staples 1 0.99
7575 EA box08 2 0.46
EA seal24 5 0.83
The data is comprised of 2 tables. There are no aggregate functions. Basically the part# and a few other columns not shown are from the first table. The descriptions, qty, and price are from another table.
If I am bringing back everything from both joined tables, how do I hide the columns that repeat on each row for each part? In this example I want to only print out the first occurance of the part number. Thank you.
January 10, 2012 at 12:30 am
Hi,
have you tried adding a row group to your tablix?
Lars
January 12, 2012 at 9:35 pm
You can easily achieve this using row groups....
Use part# to group rows..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply