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.
matrix1_BinNumber (group/sort on BinNumber),
matrix1_ItemNumber (group/sort on ItemNumber),
matrix1_ItemDescription (group/sort on ItemDescription)
matrix1_SITE (groups on SOPNUMBE, sorts by Location)
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...
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);Forum Etiquette: How to post Reporting Services problemsForum Etiquette: How to post data/code on a forum to get the best help - by Jeff ModenHow to Post Performance Problems - by Gail Shaw