Skip to Content
0
Former Member
May 09, 2008 at 11:23 AM

Dispaly of values in report

17 Views

Hello All,

The user wants to see the same characteristics in the report in each of the row. For example, the intial run of the report shows Material and quantity. The user then drills down the report by Plant. We are having Multiple plants for each material. So, when exported to excel, we do not see material against each plant. This is having problems when filtered by plant.

How it looks now:

*********************

Materail Plant Quantity

123 A 200

B 300

C 500

Below is how users want:

******************************

Materail Plant Quantity

123 A 200

123 B 300

123 C 500

What are the settings we need to make to acheive the above? Where should I make changes? I have "Unchecked" the option

Hide Repeated key values in Query properties. This did't

work 😔

Please help me.