Grouping but not displaying the query item

[Arsenal]

Hi All,

Is there a way to use a query item (for example transaction code) that can be used to group a report by (relational FM model), but not show this query item i.e. group the report by transaction code but not have transaction code show up in the report body.

Box Type None does not do it. Is there a way, at the report level, without editing the SQL?

Thanks

[rockytopmark]

Curious... why does "Box Type = none" not do it?

[Suraj]

That's what I was thinking...

[Arsenal]

If I add Transaction Code, for example, to the report body, then group it by that, and then set its box type to null, then it just disappears from the layout and when the report is run.

[Suraj]

If you can't see that item in the report, how will you know that it is grouped under that item?
For example: you group by product line for product type, when you remove product line from report, the product type will appear as you define them to appear. You won't know if product type is grouped for product line or not.
Better way is to sort the product type by product line.
In your case, sort the other columns depending upon transaction code.

[Arsenal]

that's what I was saying ....that's why setting the box type to none does not work

sorting wouldn't be the same as group ....what I need to do is group the report by transaction code without having transaction code show in the report.

[reddy_143]

Hi,

U can do it ....just cut the column from the report after grouping..

I think it will work

Regards

Suman

[MFGF]

Hi,

You need to do two things:
1. Select the List object, go to the Grouping and Sorting property, and define the grouping on your item.
2. Go to the Properties property and check the item as being a property of the list.

Regards,

MF.