mahler9 (6/18/2013)
I received an error when building the report. However, I am not certain whether or not I executed your suggestion the way you intended. Please see the attached PDF.Also, I'm wondering if\how the following report components factor into things.
Order number expression:
=replace(Fields!SOPNUMBE.Value,"DTCI","") --strips "DTCI" from SOPNUMBE
This shouldn't affect things, as long as you are not creating duplicates by stripping the prefix.
Row groups:
matrix1_BinNumber (group/sort on BinNumber),
matrix1_ItemNumber (group/sort on ItemNumber),
matrix1_ItemDescription (group/sort on ItemDescription)
Column groups:
matrix1_SITE (groups on SOPNUMBE, sorts by Location)
Thanks again!
The reason you only get Insert Row ...Above or Below is because you already have another row inside the group above the cell you are right clicking on, so it can only insert inside the group from there.
Can you post the expression you used for the column numbering?
edit: I meant to say, I just tried this on BIDS 2008 and it worked just fine...
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);