Skip to Content
0
Former Member
Dec 04, 2009 at 06:33 AM

Notable to achive "Hide Repeated Key Values" property result in Web Reporti

166 Views

Hi Gurus,

I have a report which displays the daily sales like this

Product ID.....Product Name.....Qty....Price......Tot.Amount

1.....................AAA...................2.........2.................4

..................................................3.........2.................6

..................................................4.........2.................8

..................................................5.........2...............10

..................................................6.........2...............12

2.....................BBB...................2.........3.................6

..................................................3.........3.................9

..................................................4.........3................12

..................................................5.........3................15

..................................................6.........3................18

But I want to view this report like this in Web Report result or RSRT report result

1.....................AAA...................2.........2.................4

1.....................AAA...................3.........2.................6

1.....................AAA...................4.........2.................8

1.....................AAA....................5.........2...............10

1.....................AAA....................6.........2...............12

2.....................BBB...................2.........3.................6

2.....................BBB...................3.........3.................9

2.....................BBB...................4.........3................12

2.....................BBB...................5.........3................15

2.....................BBB....................6.........3................18

I have set the Qeury property unchecked "Hide Repeated Key Values" in Query Designer. It is giving me required results

in BEx Analyzer, but I am unable to see same result in Web or RSRT.

Can anybody tell me how do I achieve this in the Web result or RSRT Result.