User 'PC/Pavan' has db_owner role in 'ReportServer' and 'ReportServerTempDB' and datasource. Following is the screenshot. I know just basics of DB security. Let me know if I am looking at...

Sorry, it was 'Standard' edition. I have corrected my question.

http://sqlandssrs.blogspot.com/2009/11/single-report-table-fetching-data-from.html

It is possible to use multiple datasets in a single report table, but only one dataset can be for detailed data; All other datasets can be used to get aggregated...