Thanks Markus.As suggested by you i tried it through Data Driven Subscription and able to generate reports individually for each region.

hi Dave,

I saw ur reply. I tried same query which u have given me in "oledb provider for microsoft directory services".but it is showing same error.

any way first i ll...