no news

i have branch server named srv1, srv2,... and database named db1, db2, ...

now on srv5 i have database db5 and db6

and in report datasource i have put the connection string...

by mistake it get posted twice...and i dont see how to remove one of them

can u explain a bit more about what you mean..

stored procedures is an alternative...but i am concerned why query is doing this on its own..

even when i write is corretly and save...its saving its own way.

i am wondering why we have to do these things in query itself...if i check Cognos, you can do all these things in report design...

by having to do these things...