Yes the datasource have access to run the proc i have designed so many reports using the same datasource and same database.

Another thing is when we select new report option and select this sp and execute data is comming but after clicking ok it is coming out of the screen.

If we select existing item option and select this sp that error message is comming