Report Studio: Auto Group & Summarize problem

[pucovsky]

Hi

I have a package containing Query Subject Definition with Generate SQL set as As View in Framework Manager.
In Report Studio I have 2 data items used from this package's Query Subject in my query:

ID - with Aggregate Function property set to None
QTY - with Aggregate Function property set to Total

Query property Auto Group & Summarize is set to Yes.

As a result I want a report of IDs grouped and QTYs related to IDs totaled.
I have 10 distinct IDs and 10 rows should be the correct result.
Unfortunately I get all 1000 detail rows, IDs aren't grouped.
What am I doing wrong here?

Can you help with this? Thx.

 

[blom0344]

The set as view has no real influence here. Your settings are all correct. The best approach is to generate the SQL and check how this looks like. Post it for our reference so we can comment..

Ties Blom