Tabular Reference Problem

[msnaidu]

In report studio ,
i have List1 using Query1 which gets the result from the Stored Procedure,then i create List2 using Query2 which is Tabular Reference to Query1.
Every time when i am running the report ,the Stored Procedure is being Called Twice.
Can anyone pls let me know whts the cause and how to resolve it??
Regards
Meera

 

[the6campbells]

A tabular reference is really a reference to the specification of a query that is merged into the query that references it.

eg. Q1=select * from T1
Q2=select * from Q1 becomes select * from ( select * from T1)
Q3=select * from T2 where .. in ( .. Q1)

So lets assume that only Q2 and Q3 are used in report layout. At runtime, the engine will 'merge' the specification of Q1 into the 'SQL' it builds for Q2 and ditto for Q3. Hence, you will see your procedure being invoked twice.