Summary report based on a set of data..

Question: All,
I have got a query to generate a summary revenue report for each month

Now the user wants the same summary report be generated for the TOP 100 or 200 clients ( can be entered at run time ).

I have a condition with TOP-N in the query now but as the Client is not in the drill-down. The Condition in the query is not being used.

SAP confirmed the same.

Could you please suggest me an alternative.

Thanks in advance

Sid

Answer:
Use replacement path variable, filled in by query

/forums/viewtopic.php?t=59424
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.


Tuly Idiot's fan club active member.

Answer:
Fred,
I tried that just now, but that didn't work.

Thanks
Sid

Answer:
Hi, Sid,
Did you try to position the Top 100/200 on the first query ?
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.


Tuly Idiot's fan club active member.

Answer:
OK, Sid, forget my question ...
I'm currently searching for a workaround, but no news for the moment.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.


Tuly Idiot's fan club active member.
Copyright ?2007 - 2008 www.jt77.com